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 ATL94LA132Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Tifton, GAThe pilot's failure to follow the aircraft checklist, resulting in an attempted takeoff with the elevator trim improperly set. A factor was the trees at the perimeter of the airstrip.Jul 8, 1994 · N9583G · DestroyedNTSB ANC94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ft Richardson, AKThe pilot's selection of unsuitable terrain for landing. A factor which contributed to the accident was the pilot's impairmentJul 8, 1994 · N8466Y · Substantial damageNTSB SEA94LA171Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Portland, ORTail rotor gearbox failure due to inadequate assembly and inspection procedures by the manufacturer.Jul 7, 1994 · N42WC · Substantial damageNTSB SEA94LA169Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Weiser, IDClearance from powerlines was not maintained. Factors include dusk light conditions.Jul 7, 1994 · N4900T · Substantial damageNTSB SEA94FA168Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Arco, IDThe pilot's diversion of his attention of controlling the airplane which led to his failure to maintain adequate airspeed. A factor which contributed to the accident was the pilot's failure to assure that the cabin door was closed and locked.Jul 7, 1994 · N5919Y · Substantial damageNTSB LAX94LA277Accident · No injuriesLimited investigationFinal reportCessna 172 · Hanford, CAThe failure of the pilot to stop the aircraft in a timely manner after landing back on the runway following a loss of engine power for undetermined reasons.Jul 7, 1994 · N61569 · Substantial damageNTSB FTW94LA229Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · South Bend, INThe encounter with unforcasted and unreported turbulence.Jul 7, 1994 · N60SW · No damageNTSB FTW94LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · England, ARThe inadvertent stall during initial takeoff climb. A factor was the tall grass.Jul 7, 1994 · N1382T · Substantial damageNTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.Jul 7, 1994 · N107JT · DestroyedNTSB ANC94LA076Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Northway, AKThe failure of the left main landing gear attachment fittings as a result of the improper welds by the maintenance repair facility. Factors in the accident that precipitated the gear failure were the wind gusts, and the pilot not adequately compensating for…Jul 7, 1994 · N9808M · Substantial damageNTSB NYC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ellisburg, NYA fuel or fuel system problem that was probably related to the pilot/owner's failure to assure proper maintenance and/or inspection of the airplane before flight. A factor related to the accident was: soft terrain in the emergency landing area.Jul 6, 1994 · N5839P · Substantial damageNTSB MIA94GA174Accident · No injuriesFinal reportAerospatiale AS-350 · Caryville, FLThe pilot's intentional continued flight into instrument meteorological conditions. Contributing to the accident was pilot fatigue.Jul 6, 1994 · N901BA · Substantial damageNTSB LAX94LA283Accident · Minor injuriesLimited investigationFinal reportMeyers ME 200 · Chico, CAA separation of the exhaust pipe from the cabin heat control valve and the lack of insulation on electrical wiring between the ammeter and the avionics bus.Jul 6, 1994 · N7MV · Substantial damageNTSB CHI94LA221Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Land O'Lakes, WIthe pilot's failure to maintain clearance with trees. Factors in the accident were the trees, the pilot's operation with known deficiencies in equipment, and the pilot's diverted attention.Jul 6, 1994 · N625P · Substantial damageNTSB SEA94LA172Accident · No injuriesLimited investigationFinal reportPitts S1 · Heber City, UTFailure of main landing gear axle hardware. Factors include collapse of main landing gear strut.Jul 5, 1994 · CGPUR · Substantial damageNTSB SEA94FA164Accident · 1 fatalField investigationFinal reportCessna 185C · Palouse, WAThe inadvertent disorientation of the pilot after entering instrument meteorological conditions. Fog was a related factor.Jul 5, 1994 · N5833T · Substantial damageNTSB MIA94LA173Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-32 · Valdosta, GAAn encounter with clear air turbulence that was not forecast nor observable on radar.Jul 5, 1994 · N901VJ · No damageNTSB LAX94LA276Accident · No injuriesLimited investigationFinal reportCessna 310J · Elko, NVthe collapse of the landing gear due to a gear strut bolt shearing in two.Jul 5, 1994 · N310BD · Substantial damageNTSB LAX94LA275Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Las Vegas, NVThe failure of the pilot to obtain the proper takeoff speed. Factors are the high density altitude and the crosswind.Jul 5, 1994 · N6959U · Substantial damageNTSB FTW94LA222Accident · No injuriesLimited investigationFinal reportCessna 206E · Cleveland, TXLoss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.Jul 5, 1994 · N4945U · Substantial damageNTSB FTW94FA220Accident · 2 fatalField investigationFinal reportSIAI-Marchetti F.260 · Dover, OKFailure of the pilot to maintain adequate altitude while performing an aerobatic demonstration. Factors related to the accident were: the pilot's inadequate training, his lack of experience in the type of operation, and insufficient FAA oversight of this type…Jul 5, 1994 · N260MS · DestroyedNTSB CHI94T#A02Accident · No injuriesClass 3Final reportContinental Copters MK 5 Tomcat · Minot, NDJul 5, 1994 · N9043T · Substantial damageNTSB CHI94DEV01Accident · Minor injuriesFinal reportHucke, Ronald L. PARSON-2P · Monmouth, ILThe pilot's failure to maintain flying speed which resulted in a stall/mush.Jul 5, 1994 · N589RH · Substantial damageNTSB CHI94DCG02Accident · 1 fatalFinal reportAero Commander Calair A-9B · Excelsior Sprgs, MOThe pilot's failure to maintain altitude clearance above the powerlines during his maintenance test application run.Jul 5, 1994 · N7965V · DestroyedNTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.Jul 5, 1994 · N7917D · DestroyedNTSB SEA94FA167Accident · 2 fatalField investigationFinal reportBeech P35 · Cedar City, UTThe pilot's failure to maintain a proper climb rate and clearance from the terrain. Factors in the accident were the high density altitude and the aircraft being above the maximum certificated gross weight.Jul 4, 1994 · N1498G · Substantial damageNTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.Jul 4, 1994 · N88114 · DestroyedNTSB NYC94LA109Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Princess Anne, MDThe pilot's failure to do a go-around and her delay in the initiating of an aborted landing, which resulted in her failure to outclimb trees during the aborted landing.Jul 4, 1994 · N4828G · Substantial damageNTSB MIA94LA171Accident · No injuriesLimited investigationFinal reportPitts S2B · Fort Lauderdale, FLThe poor welding quality of the manufacturer, resulting in the fatigue failure of the aileron attachment bracket.Jul 4, 1994 · N61PS · Substantial damageNTSB FTW94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Watson, ARWas the excessive airspeed during approach and the pilot's failure to execute a missed approach.Jul 4, 1994 · N2986M · Substantial damageNTSB SEA94LA166Accident · No injuriesLimited investigationFinal reportHughes 369HS · West Jordan, UTThe pilot not maintaining a proper descent rate and his delayed remedial action.Jul 3, 1994 · N9029F · Substantial damageNTSB MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Jul 3, 1994 · N8820Q · Substantial damageNTSB LAX94LA274Accident · No injuriesLimited investigationFinal reportHayes Dickey E-RACER · Elko, NVa fatigue fracture and separation of the propeller flange from an improperly machined propeller extension assembly. Inadequate design, substantiation, and approval of the part design was a factor in the accident.Jul 3, 1994 · N99G · Substantial damageNTSB LAX94LA273Accident · Minor injuriesLimited investigationFinal reportAdams Thorpe T-18 · Stockton, CAA vapor lock induced engine failure due to inadequate thermal shielding of the fuel pump and lines. Soft terrain in the landing area was a factor.Jul 3, 1994 · N51079 · Substantial damageNTSB LAX94FA272Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · So. Lake Tahoe, CAthe pilot's failure to maintain adequate airspeed during initial climb under high-density altitude weather conditions and a resultant inadvertent stall/spin. Factors which contributed to the accident were the pilot's overconfidence in his personal ability,…Jul 3, 1994 · N4321N · DestroyedNTSB LAX94FA271Accident · 2 fatalField investigationFinal reportCessna 195A · Santa Paula, CAthe noninstrument-rated pilot's intentional VFR flight into IMC conditions and the resultant in-flight loss of control.Jul 3, 1994 · N9300A · DestroyedNTSB FTW94LA221Accident · No injuriesLimited investigationFinal reportBell OH-13E · Mountain View, ARThe fuel exhaustion as result of a struck fuel drain valve. Factors were the high density altitude, and the unsuitable terrain at the pilot's disposal for the forced landing.Jul 3, 1994 · N39WL · Substantial damageNTSB CHI94LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Waseca, MNinadequate preflight planning/preparation and the pilot's failure to refuel the airplane. Factors related to the accident were a poorly planned forced landing approach and high vegetation.Jul 3, 1994 · N63277 · Substantial damageNTSB ATL94LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Autaugaville, ALThe pilot's inadequate preflight planning, in that he did not properly evaluate the condition of the runway prior to takeoff, and his failure to abort the takeoff when adequate acceleration was not observed. Factors were the high vegetation (grass) on the…Jul 3, 1994 · N3659D · Substantial damageNTSB ATL94LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAThe student pilot's improper use of the rudder, and his failure to maintain directional control during takeoff.Jul 3, 1994 · N67524 · Substantial damageNTSB SEA94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Lowell, IDThe pilot in command's failure to maintain adequate airspeed.Jul 2, 1994 · N8565D · DestroyedNTSB NYC94LA110Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Wareham, MAThe pilot's inadequate inflight planning which resulted in fuel exhaustion and the loss of engine power.Jul 2, 1994 · N59400 · Substantial damageNTSB NYC94LA108Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bristol, NHthe failure of maintenance personnel to remove an object from the carburetor heat duct during annual inspection which blocked induction air and resulted in the loss of engine power, and the subsequent collision with the terrain during a forced landing.Jul 2, 1994 · N734TU · Substantial damageNTSB NYC94LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Newport News, VAThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain aircraft control.Jul 2, 1994 · N97000 · Substantial damageNTSB NYC94LA105Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Put-In-Bay, OHThe pilot's inadequate control and failure to maintain directional control which resulted in collision with a sign.Jul 2, 1994 · N5716F · Substantial damageNTSB DCA94MA065Accident · 37 fatalClass 1 · MajorFinal reportDouglas DC-9-31 · Charlotte, NC1) The flightcrew's decision to continue an approach into severe convective activity that was conducive to a microburst; 2) the flightcrew's failure to recognize a windshear situation in a timely manner; 3)the flightcrew's failure to establish and maintain…Jul 2, 1994 · N954VJ · DestroyedNTSB CHI94LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Garden City, KSfuel exhaustion for reason or reasons undetermined. A factor was the rough/uneven terrain.Jul 2, 1994 · N901JM · Substantial damageNTSB CHI94LA217Accident · Minor injuriesLimited investigationFinal reportHunsberger Glasair · Lapeer, MIthe pilot's failure to maintain aircraft handling. A factor related to the accident was the gusty wind conditions.Jul 2, 1994 · N234EC · Substantial damageNTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.Jul 2, 1994 · N3649B · DestroyedNTSB ANC94IA075Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the local controller to exercise his responsibility to have each aircraft adjust its flightpath to remain clear of the other, and the failure of the pilot of the Cessna 185 to maintain adequate visual separation from the Boeing 737.Jul 2, 1994 · N769AS · 2 aircraft · No damage