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 LAX99FA270Accident · Serious injuriesField investigationFinal reportBeech J35 · Marysville, CAA loss of engine power due to improperly torque cylinder base nuts by maintenance personnel during a top overhaul.NTSB FTW99LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Snyder, TXThe loss of engine power due to fuel starvation as result of a leak in the engine fuel control. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA224Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKThe pilot's failure to maintain rotor rpm which resulted in a hard landing. A factor was the high density altitude.NTSB DEN99LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tooele, UTAn inadequate flare during landing touchdown, resulting in a fracture of the right main landing gear strut. A factor was the flight instructor's failure to properly supervise the student.NTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.NTSB CHI99LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Harsens Island, MIthe loss of engine power for undetermined reasons. Factors were the berm and the pond.NTSB ANC99LA120Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fairbanks, AKA loss of engine power for an undetermined reason. A factor was unsuitable terrain for a forced landing.NTSB ANC99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Seward, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft sand.NTSB NYC99LA204Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mansfield, MAWas the student pilot's failure to maintain lateral control of the helicopter while bringing it to a hover. A factor in the accident was the student pilot's lack of total experience in helicopters.NTSB NYC99LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, NJA loss of engine power for undetermined reason(s).NTSB FTW99LA225Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dermott, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99FA223Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · San Antonio, TXThe instructor pilot's failure to complete the Emergency Gear Extension Checklist, resulting in the inadvertent wheels-up landing. A factor was the instructor pilot's fatigued condition.NTSB FTW99FA222Accident · 1 fatalField investigationFinal reportPiper PA30 · Holdenville, OKthe pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.NTSB DEN99LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Aspen, COThe pilot's inadequate in flight planning. Factors were the high density altitude, the lack of suitable terrain for a forced landing, and the sign post that the right wing impacted.NTSB CHI99LA300Accident · No injuriesLimited investigationFinal reportMaule MXT7-180A · Lapointe, WIthe pilot not maintaining control of the airplane during a crosswind landing. A factor in this accident was inadequate remedial action by the pilot.NTSB CHI99LA299Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lambertville, MIthe inadequate aircraft preflight by the pilot and the pilot's failure to remove the aileron gust lock before flight. Factors to the accident were the soft terrain adjacent to the runway and the collapse of the nose gear.NTSB NYC99LA202Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Prattsburg, NYPropeller blade separation, resulting from fatigue cracking initiated by intergranular corrosion. A factor was the lack of propeller blade corrosion inspection requirements.NTSB NYC99LA201Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Zanesville, OHThe pilot's failure to maintain directional control.NTSB IAD99LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYwas the student pilot's improper control input and the flight instructor's delayed remedial action.NTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.NTSB CHI99LA295Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Eagle River, WIthe pilot's inadequate compensation for the crosswind conditions and the subsequent failure to maintain directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions, and the rough/uneven terrain encountered.NTSB CHI99LA294Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Johnson Creek, WIthe pilot's failure to maintain directional control of the airplane.NTSB CHI99LA292Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Hudson, MIwas an inadequate preflight and misjudged flare to landing during the autorotation by the pilot. A factor in this accident was a totally blocked fuel tank vent system.NTSB CHI99FA293Accident · 2 fatalField investigationFinal reportHudson Avenger · Lansing, ILthe weight and balance exceeded by the owner/builder. The inadequate preflight planning/preparation by the owner/builder.NTSB ATL99LA118Accident · No injuriesLimited investigationFinal reportBeech G35 · Columbus, MSThe loss of engine power for undetermined reasons and unsuitable terrain to make a forced landing.NTSB ANC99LA114Accident · No injuriesLimited investigationFinal reportCessna 206A · Cordova, AKA loss of engine power due to corrosion/blockage of the fuel flow divider vent hole. A factor was unsuitable terrain for a forced landing.NTSB SEA99LA143Accident · No injuriesLimited investigationFinal reportCessna 210B · Port Angeles, WAThe failure of maintenance personnel to detect cracked main landing gear saddles during required inspection, and subsequent fatigue fracture of the left main landing gear saddle resulting in separation of the saddle and disabling of the left main gear.NTSB NYC99FA199Accident · 3 fatalField investigationFinal reportCessna P210N · Worcester, VTThe pilot's inadequate in-flight planning/decision, his failure to follow the published instrument departure procedure for the particular runway, and his continued flight into known adverse weather. A factor was thunderstorms.NTSB LAX99LA324Accident · No injuriesLimited investigationFinal reportKilpatrick IV-1200 · Springerville, AZFailure of the pilot to maintain directional control resulting in an inadvertent groundloop. A factor was muddy terrain by the runway.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB FTW99LA228Accident · No injuriesLimited investigationFinal reportAviat S1-11B · Katy, TXThe pilot's inability to maintain directional control of the tailwheel equipped biplane following the failure of the left brake master cylinder.NTSB FTW99LA227Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Rockwall, TXThe mechanic's improper machining of the crankshaft during a major overhaul, which resulted in a fatigue crack and subsequent failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA147Accident · No injuriesLimited investigationFinal reportCessna 180H · Gillette, WYThe pilot's inadvertent ground loop during landing roll.NTSB CHI99LA302Accident · No injuriesLimited investigationFinal reportCessna 150K · Kenosha, WIThe pilot's attention being diverted into the cockpit and not maintaining visual separation with the fuel truck. A factor in the accident was the fuel truck.NTSB CHI99LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Red Wing, MNDirectional control not being maintained by the pilot. A factor to the accident was the ditch.NTSB CHI99LA289Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe failure of the ramp service clerk to maintain clearance with the operating propeller. A factor related to the accident the inattentiveness on the part of the clerk.NTSB CHI99FA296Accident · 1 fatalField investigationFinal reportJohannes-Robert Acrosport RJ-2 · Campbellsport, WIThe loss of control during initial climb for undetermined reasons.NTSB ATL99LA116Accident · Minor injuriesLimited investigationFinal reportCessna R172-E · Chiefland, FLPremature fuel exhaustion due to a cracked fuel line. Contributing to the severity of the accident was the electrical service drop line, which crossed the roadway.NTSB ANC99LA129Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Anchorage, AKThe pilot's inadequate preflight planning/preparation, and improper starting procedure.NTSB ANC99LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor was a crosswind, and an inadvertent ground loop.NTSB NYC99LA200Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Hillsborough, NHan inadequate auxiliary fuel tank installation which resulted in a leak of undetermined origin.NTSB NYC99FA198Accident · 2 fatalField investigationFinal reportCessna 210 · Mount Pocono, PAThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain aircraft control. A related factor was the fog.NTSB MIA99FA224Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pembroke Pines, FLThe failure of the pilot to maintain airspeed and inadvertent stall of the airplane by the pilot-in-command resulting in the uncontrolled descent and in-flight collision with a house. Contributing factors in the accident were the loss of engine power due to…NTSB MIA99FA219Accident · 1 fatalField investigationFinal reportBeech B-58 · Panacea, FLThe pilot's excessive speed and extended touchdown point during landing resulting in an inability to stop the airplane within the length of the wet, grass runway, and the subsequent on-ground collision with the airport fence and trees.NTSB FTW99LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 502B · Guthrie, TXThe pilot's inadequate weather evaluation prior to takeoff. Factors associated with the accident were an inadequate wind direction indicator, a sudden windshift, and a tailwind.NTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.NTSB CHI99FA290Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Paw Paw, MIthe pilot flew into known adverse weather, the pilot's lack of total instrument flight experience, and the pilot exceeded the design limits of the airplane. Factors included the pilot's total lack of experience in the type of operation and the pilot's…NTSB ATL99LA117Accident · No injuriesLimited investigationFinal reportQuicksilver GT-500 · Ormond Beach, FLThe in-flight collision with an object for an undetermined reasons. A factor was the stolen/unauthorized use of the airplane.NTSB FTW99LA220Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Humphrey, ARFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB FTW99LA219Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Wayton, ARThe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during a go-around. Factors were the gusty wind condition, and the high density altitude. Factors associated with the accident were gusty winds, and a…