NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW99LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Wharton, TXThe pilot's failure to comply with the manufacturer's single engine landing checklist which resulted in the aircraft landing short of the runway.NTSB DCA99WA035Accident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Naples, ItalyNTSB ATL99FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Brevard, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC99LA053Accident · Serious injuriesLimited investigationFinal reportGrove AIR Command · Centre Hall, PAThe pilot's failure to maintain clearance from a power line. A factor was the sunglare.NTSB CHI99LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Hyannis, NEthe pilot's failure to maintain clearance with the transmission line. Factors associated with the accident were the transmission line, the low altitude at which the pilot was flying, and his diverted attention to a person on the ground.NTSB MIA99LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Charleston, SCthe total loss of engine power caused by an oil leak at the oil filter adapter, resulting in a broken connecting rod, a subsequent forced landing and impact with rough terrain.NTSB LAX99LA082Accident · No injuriesLimited investigationFinal reportCessna 172L · Santa Paula, CAThe instructor pilot's misjudged altitude and speed, which resulted in a failure to attain the proper touchdown point causing an overrun and collision with a block wall. A factor was the wet runway, which may have hindered brake effectiveness.NTSB FTW99LA071Accident · No injuriesLimited investigationFinal reportCessna 172E · Guymon, OKThe pilot's failure to maintain aircraft control. A factor was the gusty crosswind.NTSB MIA99LA068Accident · No injuriesLimited investigationFinal reportCessna 310N · Clearwater, FLa ground fire in the left wing due to an undetermined ignition source.NTSB FTW99LA069Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Nemo, TXA partial loss of engine power due to the obstructed fuel vent line and fuel cap vent.NTSB CHI99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elmo, MNthe student pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the snow covered, icy runway condition and the snowbank which the airplane contacted.NTSB CHI99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Rockford, ILthe failure of the pilot to maintain flying speed and ground clearance while on a night circling approach. Factors were existing icing conditions and the airframe and windshield icing.NTSB LAX99LA081Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Lemoore, CAThe inadequate nature of the operator's maintenance, which failed to detect the primer and magneto discrepancies. An overly lean fuel mixture and/or magneto cross firing resulted in detonation, an ensuing connecting rod failure, and a total loss of engine…NTSB LAX99FA080Accident · 2 fatalField investigationFinal reportNorth American T-6G-NA · New River, AZThe pilot's delayed recovery after an intentional stall/spin of 3 to 4 rotations. A factor was the pilot's inadequate entry altitude for the intended maneuver.NTSB FTW99LA070Accident · No injuriesLimited investigationFinal reportCessna 180J · Granbury, TXThe loss of engine power due to an undetermined reason. A factor was the power lines crossing the final approach path.NTSB NYC99LA052Accident · No injuriesLimited investigationFinal reportBeech 1900D · Hyannis, MAThe captain's improper placement of the power levers in the BETA position, while the airplane was inflight. Factors were the fog and dusk conditions.NTSB NYC99LA051Accident · No injuriesLimited investigationFinal reportCessna 650 · Columbus, OHThe collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.NTSB CHI99FA075Accident · 2 fatalField investigationFinal reportBeech BE-55 · Elkhart, INthe pilot failed to maintain a proper glidepath and obstacle clearance. Factors were the fog and dark night.NTSB CHI99FA072Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Pellston, MIthe pilot's failure to maintain proper altitude/clearance on the approach and his flight into known icing conditions. Factors relating to this accident were the pilot flying with known equipment deficiencies, the pilot's physical impairment (alcohol), the…NTSB MIA99LA066Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW27 · Winter Haven, FLan in-flight collision with wires.NTSB LAX99LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe CFI's loss of airplane control upon encountering a dust devil due to his improper in-flight decision to land in proximity to the observed adverse weather conditions.NTSB FTW99LA068Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Edmond, OKThe pilot's failure to attain the proper touchdown point due to excessive airspeed and his failure to abort the landing. Factors were the pilot's excessive braking and the short, grass runway.NTSB SEA99IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 747-238B · Pacific Ocean (Pacific Ocean)An encounter with Clear Air Turbulence at Flight Level 330.NTSB LAX99FA078Accident · 1 fatalField investigationFinal reportCessna 182P · Danville, CAThe pilot's disregard for the preflight weather briefing, and his intentional continuation into adverse weather conditions.NTSB DEN99FA034Accident · 3 fatalField investigationFinal reportCessna P210N · Albuquerque, NMTotal failure of the vacuum system, and failure of the pilot to maintain aircraft control, resulting in wing spar failure. Factors were the pilot's spatial disorientation, and his exceeding the design stress limits of the airplane.NTSB CHI99LA071Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOthe instructor pilot's failure to maintain aircraft control. Factors contributing to this accident were the snow covered grassy field area along the side of the runway and the pile of snow.NTSB CHI99LA069Accident · No injuriesLimited investigationFinal reportCessna 150C · Middleton, WIinadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.NTSB SEA99LA031Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Tensed, IDThe pilot-in-command's inadequate fuel management which resulted in fuel exhaustion. Contributing factors were the absence of cautionary markings on the fuel gauge, and high trees at the accident site.NTSB LAX99FA077Accident · 4 fatalField investigationFinal reportBeech F35 · Chino, CAThe pilot's intentional flight into known instrument meteorological conditions in hilly terrain and his failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's inadequate evaluation of the weather conditions, dark night…NTSB CHI99LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Hillsdale, MIthe pilot's disregarding preparation for the flight. Factors were a frozen landing gear wheel, and the snowbank.NTSB CHI99LA070Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Schaumburg, ILthe pilot's failure to maintain directional control of the airplane. A factor associated with the accident was the snowbank which the airplane contacted.NTSB ANC99IA025Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Fairbanks, AKThe improper overhaul of the thrust reverser pneumatic drive unit, and the subsequent failure of the thrust reverser actuator. Factors associated with the incident were the inadequate quality assurance procedures by the overhaul company.NTSB LAX99RA235Incident · No injuriesForeign investigationCessna 550 · Paris, FranceNTSB FTW99LA093Accident · No injuriesLimited investigationFinal reportBeech G35 · Ennis, TXFlutter of the empennage for an undetermined reason, which resulted in damage to the aft fuselage.NTSB DEN99IA033Incident · No injuriesIncident investigationFinal reportBeech E90 · Clovis, NMTotal failure of the elevator control cable due to a short circuit from chafing against an adjoining electrical cable, and failure of maintenance personnel to detect the problem during an AAIP phase inspection.NTSB LAX99LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Burson, CAThe pilot's failure to maintain adequate airspeed while maneuvering to avoid an obstacle immediately after takeoff. A factor in the accident was the pilot's inadequate examination of the off-airport takeoff area in order to identify potential hazards.NTSB LAX99LA074Accident · No injuriesLimited investigationFinal reportAbraham J G II/Erickson K ONE Design · No Las Vegas, NVThe separation of the left rudder control cable from the rudder horn due to the improper installation of a nicopress fitting that secured the cable to the control horn.NTSB FTW99FA067Accident · 4 fatalField investigationFinal reportCessna 182B · Honobia, OKThe pilot's failure to maintain aircraft control for an undetermined reason.NTSB DCA99RA033Accident · 4 fatalForeign investigationCessna CE-208 · Jumla, NepalNTSB CHI99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Charles, ILA loss of engine power due to fuel exhaustion. Also causal was the pilot's inadequate preflight/planning preparation which led to inadvertent flight into instrument meteorological conditions and him becoming lost/disoriented. Contributing to the accident were…NTSB SEA99LA030Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Moses Lake, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB LAX99LA075Accident · No injuriesLimited investigationFinal reportHanson Hanson Tailwind W-8 · Chula Vista, CAThe loss of lubrication to the number 3 rod bearing and the resulting failure of the number 3 connecting rod. A contributing factor to the accident was the soft terrain at the accident location.NTSB DEN99LA032Accident · No injuriesLimited investigationFinal reportCessna 182M · Longmont, COThe pilot's poor judgment by intentionally buzzing. A factor was an unfavorable wind that caused inadequate altitude/clearance to maneuver and avoid nearby houses.NTSB CHI99LA067Accident · Minor injuriesLimited investigationFinal reportBaker Fisher Horizon · Bolivar, MOThe pilot's improper use of carburetor heat which resulted in carburetor icing and subsequent loss of engine power.NTSB CHI99LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Creal Springs, ILwas the pilot having the fuel tank selector in the improper position and not following the airplane manufacturer's emergency procedures to restore a loss of power. A factor in this accident was fuel starvation.NTSB NYC99LA050Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9 · Plainfield, PAThe wake turbulence from the proceeding Boeing 747.NTSB NYC99LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lynchburg, VAFuel exhaustion for undetermined reasons.NTSB IAD99LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Fairfield, NJThe flight instructor's failure to maintain rotor rpm and his failure to complete the autorotational descent. A factor in the accident was the flight instructor's failure to fully deploy carburetor heat as directed in the Pilot's Operating Handbook.NTSB IAD99LA027Accident · No injuriesLimited investigationFinal reportCessna 421B · Youngstown, OHThe pilot's failure to maintain aircraft control. A factor was the icy runway.NTSB DCA99WA031Accident · No injuriesForeign investigationBoeing 767-300 · London, United Kingdom