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 CHI93LA230Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Ionia, MIThe pilot in command's failure to maintain the proper glidepath.NTSB CHI93LA229Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Point Lookout, MOThe pilot in command's failure to maintain proper glide path, and her failure to attain the proper touch down Point.NTSB CHI93LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · West Chicago, ILthe pilot's improper use of carburetor heat. Conditions conducive to the formation of carburetor ice was a factor.NTSB CHI93FA225Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elwell, MIImproper use of the fuel selector by the pilot, which resulted in fuel starvation.NTSB ATL93LA117Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Cleveland, GAThe pilot's improper use of carburetor heat, resulting in a partial loss of engine power during the initial climb. Factors were the carburetor icing conditions, and the trees located at the departure end of the airstrip.NTSB SEA93LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bozeman, MTDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB FTW93LA196Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Edgard, LAThe pilot's attempt to takeoff under conditions that exceeded the performance capability of the aircraft. A factor was the high density altitude.NTSB DEN93LA069Accident · 1 fatalLimited investigationFinal reportIrving Siewert Osprey GP-4 · Canon City, COFailure by the pilot/builder to follow construction specifications and the use of improper materials during construction of the aircraft.NTSB CHI93LA233Accident · Minor injuriesLimited investigationFinal reportBeech E35 · Virgil, ILThe pilot's failure to abort takeoff.NTSB CHI93LA231Accident · No injuriesLimited investigationFinal reportMooney M20C · Eveleth, MNThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA228Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownsburg, INfailure to replace a dirty air filter.NTSB CHI93LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Cloud, MNthe pilot's improper starting procedures.NTSB CHI93FAMS4Accident · 1 fatalMissing aircraftFinal reportMooney M20K · Hobart, INundetermined.NTSB ATL93LA116Accident · No injuriesLimited investigationFinal reportGrumman G164A · Brundidge, ALThe broken carburetor accelerator pump piston rivet which lodged under the needle valve, allowed the float chamber to flood with fuel, and the engine to quit. The lack of suitable terrain for a forced landing was a factor.NTSB NYC93LA126Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sanford, METhe pilot's failure to maintain directional control of the helicopter while hovering, resulting in the main rotor blades impacting the ground.NTSB CHI93LA224Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Baraboo, WIan encounter with moderate turbulence in the clouds.NTSB ATL93LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Statesville, NCThe improper use of carburetor heat by the pilot. A factor in the accident was the carburetor icing conditions.NTSB ANC93LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Nondalton, AKThe inadequate preflight preparation by the pilot-in-command. A factor in the accident was the encounter with unsuitable terrain during the emergency descent.NTSB ANC93LA101Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Comet Mine, AKLoss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain on which an emergency landing could be made successfully.NTSB FTW93LA195Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A Dromader · Wheatley, ARThe pilot's operation of the airplane beyond its takeoff performance limitations and inadvertent stall. A factor was high density altitude.NTSB CHI93LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rapid City, SDThe pilot in command's inadequate compensation for wind conditions.NTSB CHI93LA219Accident · No injuriesLimited investigationFinal reportBeech B19 · Victoria, MNThe loss of engine power due to a jammed carburetor float and the inability of the pilot to maintain clearance during the emergency landing.NTSB SEA93LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ephrata, WAUndetermined loss of power and the lack of suitable terrain. A factor contributing to the accident was dark night conditions.NTSB ATL93LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Smyrna, TNThe improper flare and the improper go around procedures used by the pilotNTSB NYC93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wyantskill, NYInadequate supervision and delayed remedial action by the flight instructor. The student pilot's failure to maintain directional control and his inexperience is a contributing factor.NTSB LAX93LA265Accident · No injuriesLimited investigationFinal reportCulver LCA · San Luis Obispo, CAThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the pilot's lack of recent flight experience in tail wheel aircraft.NTSB LAX93LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Camarillo, CAFuel exhaustion due to the inadequate preflight fuel consumption planning, the inadequate en route fuel consumption calculations, and the failure of the pilot to stop en route for fuel.NTSB CHI93FA218Accident · 1 fatalField investigationFinal reportCessna 172F · Miami, MOthe pilot's failure to maintain aircraft control.NTSB SEA93LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Provo, UTThe wild animals on the runway. A factor relating to the accident was the dark night light conditions.NTSB SEA93LA135Accident · Minor injuriesLimited investigationFinal reportBell 206B · Harlem, MTThe improper refueling system procedures which allowed water to contaminate the aircraft fuel and the pilot's inadequate preflight.NTSB NYC93LA130Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Beach City, OHThe pilot's failure to maintain adequate airspeed and his diverted attention which resulted in an inadvertent stall and inflight collision with the ground.NTSB NYC93LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Louisville, KYA partial power loss of undetermined origin while operating over unsuitable terrain.NTSB MIA93FA145Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Pensacola, FLThe pilot's failure to maintain control of the airplane due to alcohol impairment. The dark night was a contributing factor.NTSB LAX93LA263Accident · Minor injuriesLimited investigationFinal reportSill/Thomas Long EZ · Lone Pine, CAthe failure of the number four cylinder exhaust valve due to excessive heat exposure and lack of maintenance.NTSB FTW93FA192Accident · Minor injuriesField investigationFinal reportBell 206L-3 · West Monroe, LAThe pilot's inadequate planning and preparation prior to takeoff, and his failure to maintain obstacle clearance. Factors were the fog and low ceilingNTSB DEN93LA071Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Watkins, COTotal loss of power resulting from a blocked carburetor fuel filter. A factor was: soft terrain encountered during the forced landing.NTSB CHI93LA217Accident · No injuriesLimited investigationFinal reportCessna P210 · Pulaski, ILthe pilot's improper fuel tank selection resulting in fuel starvation. A factor in the accident is the soft emergency landing surface.NTSB CHI93LA215Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilton, NDFailure of the engine-driven fuel pump. A factor was the pilot's failure to select the auxiliary fuel pump.NTSB ANC93LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Victory, AKThe pilot selected unsuitable terrain for landing.NTSB ANC93LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKSeparation of the right main landing gear wheel.NTSB SEA93LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTThe student pilot's selection of a closed runway for landing. Factors contributing to the accident were the student pilot's anxiety and the rough landing surface.NTSB NYC93LA122Accident · 1 fatalLimited investigationFinal reportSmitrvich Starduster SA-300A · Millville, NJThe pilot's inflight planning which resulted in fuel exhaustion. A factor was inadequate preflight planning.NTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.NTSB MIA93RA146Accident · No injuriesForeign investigationCessna 421A · Aruba, ArubaNTSB MIA93LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G · Panama City, FLImproper planning/decision by the pilot-in-command and his failure to maintain rotor RPM, which resulted in failure of the helicopter to attain effective translational lift. Factors related to the accident were: the fence & terrain conditions.NTSB LAX93LA262Accident · No injuriesLimited investigationFinal reportCessna 182F · Fallon, NVthe pilot's failure to detect and avoid a guy wire from a power pole during the landing roll on a private farm airstrip.NTSB LAX93LA261Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas 369D · Half Moon Bay, CAthe pilots failure to maintain an adequate clearance from the light tower and associated electrical power cables. Factors in the accident were; 1) pilot fatigue due to an excessively long duty day, and 2) glare from the lights which affected the pilot's…NTSB LAX93LA259Accident · 1 fatalLimited investigationFinal reportRaymond Long EZ · Groveland, CAThe pilot's failure to maintain a proper glide path during final approach. A factor in the accident was sun glare in the pilot's line of vision.NTSB LAX93FA260Accident · 1 fatalField investigationFinal reportHughes 269A · Henderson, NVthe pilot's improper use of the collective control and his failure to maintain adequate RPM during an autorotative descent during a practice power off landing. A factor which contributed to the accident related to the pilot's lack of recent experience…NTSB FTW93LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hondo, TXThe pilot's improper evaluation of the weather which led to the downwind takeoff. Factors were the windshift and the tailwind.