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.

NTSB NYC94LA153Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Scriba, NYThe pilot's failure to maintain adequate airspeed which resulted in a stall and inflight collision with trees.Aug 6, 1994 · N94151 · Substantial damageNTSB NYC94LA152Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Schuylerville, NYthe pilots failure to maintain adequate airspeed, which resulted in a stall/mush.Aug 6, 1994 · N3441E · Substantial damageNTSB NYC94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Pittstown, NJThe pilot's premature lift off and failure to attain adequate airspeed.Aug 6, 1994 · N9686B · Substantial damageNTSB NYC94LA150Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Newport, RIThe pilot's inflight planning/decision and failure to attain the proper touchdown point.Aug 6, 1994 · N119RJ · Substantial damageNTSB LAX94LA307Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Agua Dulce, CAthe pilot's poorly planned approach and improper remedial action. Factors relating to this accident were the high density altitude and prevailing tailwind.Aug 6, 1994 · N701SH · DestroyedNTSB LAX94FA309Accident · 3 fatalField investigationFinal reportAero Commander 112 · Mohave Valley, AZFailure of the certified flight instructor to properly judge the flare to avert a hard landing, and the failure of other maintenance personnel to properly repair the engine case halves during engine overhaul. A factor in the accident was the uneven relief of…Aug 6, 1994 · N1018J · DestroyedNTSB FTW94LA263Accident · No injuriesLimited investigationFinal reportBeech B36TC · Gunnison, COAn inadvertent stall. Factors were a premature lift off and high density altitude.Aug 6, 1994 · N6368C · DestroyedNTSB CHI94LA269Accident · Serious injuriesLimited investigationFinal reportCessna 150F · East Tawas, MIinadequate prelight planning/preparation by the pilot and the subsequent inadequate fuel supply.Aug 6, 1994 · N7760F · Substantial damageNTSB BFO94LA130Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Morris, PAThe pilot misjudged altitude and distance, which resulted in an undershoot of the runway.Aug 6, 1994 · N1074E · Substantial damageNTSB BFO94LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Edgewater, MDThe pilot's inadequate preflight inspection which failed to detect water contaminated fuel which resulted in fuel starvation.Aug 6, 1994 · N5242T · DestroyedNTSB ANC94LA099Accident · No injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe pilot's failure to use the available longer portion of the lake for the takeoff run.Aug 6, 1994 · N5120X · Substantial damageNTSB LAX94LA306Accident · No injuriesLimited investigationFinal reportHughes 269C · Puunene, Maui, HIthe improper overhaul of the red blade main rotor damper, and the inadequate maintenance condition of the other rotor dampers and the landing gear dampers, which led to an uncorrectable ground resonance vibration and a subsequent rollover.Aug 5, 1994 · N8376F · Substantial damageNTSB FTW94LA261Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Dallas, TXThe loss of engine power due to failure of the starter gear and shaft assembly needle bearing. Factors were the dark night conditions and the lack of suitable terrain for a forced landing.Aug 5, 1994 · N60124 · Substantial damageNTSB FTW94FA262Accident · 1 fatalField investigationFinal reportGrumman G-164B · Henderson, LAThe pilot's failure to maintain clearance from a known object.Aug 5, 1994 · N6804Q · DestroyedNTSB ANC94LA098Accident · No injuriesLimited investigationFinal reportCessna 206 · Juneau, AKThe total loss of power for undetermined reasons. The pilot's failure to follow the prescribed procedure for the use of the auxiliary fuel boost pump switch, operating the airplane with a improperly operating switch, and the lack of suitable terrain in the…Aug 5, 1994 · N9120M · Substantial damageNTSB ANC94LA097Accident · No injuriesLimited investigationFinal reportCessna 206 · Mosquito Flats, AKThe missing number 6 cylinder piston pin cap and the subsequent failure of the number 6 cylinder connecting rod cap. Also, the lack of suitable landing area for the forced landing.Aug 5, 1994 · N5200X · Substantial damageNTSB SEA94LA204Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Bend, ORImproper use of the carburetor heat by the pilot, which resulted in a loss of engine performance. A factor related to the accident was: rough terrain in the emergency landing area.Aug 4, 1994 · N6276M · Substantial damageNTSB NYC94FA148Accident · 1 fatalField investigationFinal reportBeech A100 · Williamstown, MAthe pilot's failure to maintain minimum control speed after an undetermined loss of engine power, which resulted in an inadvertent stall at too low of an altitude to allow recovery.Aug 4, 1994 · N7GA · DestroyedNTSB MIA94LA191Accident · No injuriesLimited investigationFinal reportAyres S2R · Ruleville, MSThe pilot-in-command's misjudgement of his altitude while maneuvering on an aerial application/swath run, resulting in an in-flight collision with terrain and subsequent nose over.Aug 4, 1994 · N4007P · DestroyedNTSB FTW94LA271Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Clint, TXThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 4, 1994 · N4890X · Substantial damageNTSB CHI94LA266Accident · Serious injuriesLimited investigationFinal reportBeech B33 · Imperial, NEthe failure of the pilot-in-command to maintain directional of the airplane during takeoff.Aug 4, 1994 · N786AA · DestroyedNTSB ANC94LA108Accident · No injuriesLimited investigationFinal reportStinson 108 · Salcha, AKThe pilot did not maintain control of the airplane. A factor in the accident was the pilot's lack of total experience in the specific make/model/type of aircraft.Aug 4, 1994 · N97294 · Substantial damageNTSB ANC94LA101Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · North Pole, AKThe improper rigging of the airplane's ailerons by the pilot. A factor in the accident was the pilot's improper preflight.Aug 4, 1994 · N315C · Substantial damageNTSB NYC94LA147Accident · No injuriesLimited investigationFinal reportGlobe GC1-A · Columbus, OHwas the pilot's improper recovery from a bounced landing which resulted in the airplane departing the runway, striking a light, and ground looped.Aug 3, 1994 · N81LM · Substantial damageNTSB NYC94FA145Accident · 1 fatalField investigationFinal reportCessna 210N · Martinsburg, WVFailure of the pilot to maintain adequate altitude and proper climb during the missed approach. Factors related to the accident were: darkness, fog, and conditions conducive to pilot fatigue.Aug 3, 1994 · N4875U · DestroyedNTSB FTW94LA260Accident · Serious injuriesLimited investigationFinal reportMaule M-5-210TC · Mosca, COThe pilot's failure to attain the proper touchdown point.Aug 3, 1994 · N5641A · Substantial damageNTSB FTW94LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Booneville, ARThe proper touchdown point not obtained due to excessive airspeed during the approach and landing.Aug 3, 1994 · N7276W · Substantial damageNTSB CHI94LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Spiritwood, NDthe failure of the fuselage tubing in the empennage.Aug 3, 1994 · N6568Z · Substantial damageNTSB CHI94LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Richmond, MOa loss of engine power due to fuel starvation, reason undetermined.Aug 3, 1994 · N4854T · Substantial damageNTSB CHI94LA264Accident · No injuriesLimited investigationFinal reportBeech D17R · Sandwich, ILthe failure of the pilot to lower the landing gear. Factors related to the accident were the loss of engine rpm, for undetermined reasons, and the diverted attention of the pilot.Aug 3, 1994 · N35E · DestroyedNTSB ATL94LA150Accident · No injuriesLimited investigationFinal reportCessna 150J · Waxhaw, NCA loss of engine power due to a stuck, and worn, exhaust valve, and the inadequate inspection of the engine by other maintenance personnel. A factor was the trees at the forced landing area.Aug 3, 1994 · N60182 · DestroyedNTSB NYC94LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Crown Point, NYThe pilot's failure to maintain adequate terrain clearance. Other related factors are cloud conditions and the pilot's failure to maintain flight in visual meteorological conditions.Aug 2, 1994 · N4887Y · DestroyedNTSB FTW94LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARTotal loss of engine power as the engine seized due to a blower bearing failure. A factor was the lack of suitable terrain for the forced landing.Aug 2, 1994 · N45297 · Substantial damageNTSB CHI94LA267Accident · No injuriesLimited investigationFinal reportDe Havilland Tiger Moth DH-82A · Interlochen, MIthe failure of the pilot to obtain the proper climb rate, and inadequate compensation for wind conditions.Aug 2, 1994 · N38KH · Substantial damageNTSB CHI94LA261Accident · No injuriesLimited investigationFinal reportCessna 172 · Aberdeen, SDthe pilot's failure to maintain directional control during landing. A related factor is the dark night conditions.Aug 2, 1994 · N35790 · Substantial damageNTSB CHI94FA263Accident · 2 fatalField investigationFinal reportPiper PA-25 · Decatur, NELoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.Aug 2, 1994 · N6440Z · DestroyedNTSB CHI94FA262Accident · 1 fatalField investigationFinal reportGrumman HU-16 · St. Ignace, MIThe pilot's failure to follow good seaplane operating practices by taxiing with power at forward thrust, with a tailwind, at a speed that necessitated using reverse thrust to arrest the excessive speed, and the pilot's misjudgment of his distance from the…Aug 2, 1994 · N7025N · Minor damageNTSB ANC94LA096Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's failure to maintain rotor RPM. Factors were the ravine and the tailwind.Aug 2, 1994 · N2622M · Substantial damageNTSB SEA94LA202Accident · 1 fatalLimited investigationFinal reportGroce Vans RV-4 · Glendive, MTAirspeed was not maintained after takeoff. A factor was high density altitude.Aug 1, 1994 · N7GJ · DestroyedNTSB NYC94LA144Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-8-311 · Washington, DCThe vehicle operator's improper handling of the baggage tractor resulting in loss of control of a second baggage tractor being pushed and its subsequent collision with the airplane.Aug 1, 1994 · N433AW · Substantial damageNTSB MIA94WA189Accident · No injuriesForeign investigationPiper PA28-180 · Great Inagua, Turks & Caicos IslandsAug 1, 1994 · N7184W · Substantial damageNTSB FTW94LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Bosco, LAThe pilot's failure to maintain clearance with the telephone pole.Aug 1, 1994 · N9152C · DestroyedNTSB FTW94LA253Accident · No injuriesLimited investigationFinal reportHughes 269A · Leander, LAInadequate maintenance and a fatigue failure of a #1 cylinder connecting rod bolt. A factor was the lack of suitable terrain available to the pilot for a forced landing.Aug 1, 1994 · N9062G · Substantial damageNTSB FTW94FA258Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Hunter, ARInadvertent stall due to pilot's failure to maintain airspeed. A factor was the pilot's over confidence in his personal ability.Aug 1, 1994 · N23358 · Substantial damageNTSB CHI94LA259Accident · No injuriesLimited investigationFinal reportStugart Vans RV-6 · Carthage, MOfailure of the pilot to maintain directional control during landing and unsuitable terrain encountered during the landing roll.Aug 1, 1994 · N29PT · Substantial damageNTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.Aug 1, 1994 · N7960M · Substantial damageNTSB CHI94FA258Accident · Minor injuriesField investigationFinal reportKeuthan, Charles J. Buccaneer II · Oshkosh, WIthe pilot's inadvertent stall of the airplane. Factors were the tailwind condition and the pilot's inadequate compensation for the tailwind.Aug 1, 1994 · N5296C · Substantial damageNTSB CHI94FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wellington, KSthe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall-spin. Factors were fuel exhaustion resulting from improper fuel calculations by the pilot.Aug 1, 1994 · N3693M · DestroyedNTSB SEA94GA203Accident · 1 fatalFinal reportHughes OH-6A · Duchesne, UTThe pilot's improper in-flight planning/decision and failure to maintain sufficient altitude/clearance from the surrounding terrain. Factors related to the accident were: thunderstorms in the area (requiring the pilot to deviate from the desired course), high…Jul 31, 1994 · N12UT · DestroyedNTSB SEA94FA199Accident · 2 fatalField investigationFinal reportPiper PA-12 · Salem, ORFailure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.Jul 31, 1994 · N2368M · Minor damage