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 NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.Jul 19, 1994 · N63EA · 2 aircraft · Substantial damageNTSB MIA94LA180Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lutz, FLThe certified flight instructor's improper supervision of the student pilot during a wheel landing resulting in an on ground loss of control (inadvertent ground loop). Contributing to the accident was the student pilot's improper use of flight controls and…Jul 19, 1994 · N9354E · Substantial damageNTSB LAX94LA293Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Tehachapi, CAthe pilot's failure to secure the canopy before takeoff, and his failure to maintain directional control during landing rollout.Jul 19, 1994 · N38366 · Substantial damageNTSB LAX94FA292Accident · 1 fatalField investigationFinal reportCessna 414 · Taft, CAThe pilot's inadequate preflight planning/preparation and selection of the wrong runway for takeoff. Factors related to the accident were: the uphill slope of the runway, tailwind, high density altitude, and failure of the pilot to correctly configure the…Jul 19, 1994 · N414RH · DestroyedNTSB FTW94LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Marianna, ARA premature liftoff. Factors were the tall, wet grass and a tail wind component.Jul 19, 1994 · N6073J · DestroyedNTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.Jul 19, 1994 · N6580Z · Substantial damageNTSB ATL94LA143Accident · No injuriesLimited investigationFinal reportCessna 182F · Raeford, NCAn engine power loss due to water in the fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the presence of trees at the forced landing area.Jul 19, 1994 · N3513U · Substantial damageNTSB SEA94FA182Accident · 1 fatalField investigationFinal reportCessna 172K · Patos Island, WAThe pilot's impairment of judgment and performance due to drugs (marijuana), and his improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees, while taking off toward the closed end of a cove.Jul 18, 1994 · N7417G · Substantial damageNTSB LAX94LA290Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Banning, CAthe pilot's failure to obtain and maintain an appropriate climb airspeed after lift-off which resulted in an inadvertent stall mush condition. Factors in the accident were the high-density altitude condition, the pilot's selection of a runway with an uphill…Jul 18, 1994 · N4487X · DestroyedNTSB CHI94DCA02Accident · Minor injuriesFinal reportSchweizer G-164B · Harviell, MOthe separation of the oil supply line to the propeller governor, which resulted in the propeller inadvertently going into feather. Factors were the pilots intentional ground loop of the airplane to avoid impacting obstructions at the end of the runway.Jul 18, 1994 · N48484 · Substantial damageNTSB ATL94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Samson, ALThe failure of the aileron torque tube bolt from fatigue, which resulted in an inflight loss of aircraft control and collision with terrain.Jul 18, 1994 · N4242X · Substantial damageNTSB ANC94LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe failure of the throttle control lever arm as a result of the improper 100 hour inspection by company maintenance personnel.Jul 18, 1994 · N4685F · Substantial damageNTSB ANC94LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's failure to maintain directional control.Jul 18, 1994 · N9278C · Substantial damageNTSB ANC94FA087Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Mccarthy, AKThe pilot's inadvertent use of the parking brake during the takeoff and not aborting the takeoff. A factor in the accident was the pilot's improper use of the airplane checklist.Jul 18, 1994 · N6CC · Substantial damageNTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.Jul 17, 1994 · N144US · Substantial damageNTSB SEA94LA183Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Pilot Rock, ORDirectional control was not maintained for undetermined reasons.Jul 17, 1994 · N9645A · Substantial damageNTSB NYC94LA127Accident · Minor injuriesLimited investigationFinal reportHawk RUL-1 · Lucasville, OHThe pilot's improper use of flight controls during the landing flare. A factor related to the accident was the pilot's lack of recent flight experience in this type airplane.Jul 17, 1994 · N5296Y · Substantial damageNTSB LAX94LA288Accident · No injuriesLimited investigationFinal reportCessna 177 · Rota Island (Pacific Ocean)The pilot's porpoising the aircraft upon landing and his inadequate recovery from a bounced landing.Jul 17, 1994 · N1423C · Substantial damageNTSB LAX94FA289Accident · 4 fatalField investigationFinal reportCessna 172M · Sacramento, CAthe failure of the pilot to maintain adequate airspeed while maneuvering after takeoff and his failure to retract the flaps prior to departure. A factor in this accident was the pilot's lack of recent experience.Jul 17, 1994 · N1259U · DestroyedNTSB CHI94LA235Accident · No injuriesLimited investigationFinal reportBeech 17 · Elgin, NEthe pilot's failure to maintain clearance with the road sign. Factors in the accident were the sign and the failure of the landing gear to extend into the full down and locked position.Jul 17, 1994 · N1184V · Substantial damageNTSB CHI94LA231Accident · No injuriesLimited investigationFinal reportCessna 150 · Alton, ILthe student pilot's improper recovery from a bounced landing. A factor associated with the accident is the student pilot's misjudged landing flare.Jul 17, 1994 · N3639V · Substantial damageNTSB ANC94LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe failure of the pilot to maintain the appropriate airspeed. A factor in the accident was the gusty wind.Jul 17, 1994 · N7883D · Substantial damageNTSB NYC94FA128Accident · 4 fatalField investigationFinal reportCessna K172R · Tremont City, OHFailure of the pilot to maintain control of the airplane. A factor related to the accident was: the pilot's lack of experience in the type of operation.Jul 16, 1994 · N1124V · DestroyedNTSB LAX94LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elko, NVthe pilots attempted takeoff with a strong and gusty tailwind.Jul 16, 1994 · N6785W · Substantial damageNTSB LAX94LA286Accident · 2 fatalLimited investigationFinal reportCessna 150D · Carrville, CAa loss of engine power for undetermined reasons. The mountainous terrain and lack of a suitable forced landing area within gliding distance was a factor in the accident.Jul 16, 1994 · N6052T · DestroyedNTSB FTW94LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Littlefield, TXAn inadvertent stall. Factors were low altitude and airspeed at the beginning of the downwind turn.Jul 16, 1994 · N33915 · Substantial damageNTSB CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.Jul 16, 1994 · N7079R · Substantial damageNTSB ATL94LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Vidalia, GAThe pilot's inadequate preflight planning, and his failure to refuel the aircraft, resulting in fuel exhaustion and engine stoppage. A factor were the trees at the forced landing area.Jul 16, 1994 · N6074G · Substantial damageNTSB ATL94LA140Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Cochran, GAThe pilot's failure to maintain airspeed and clearance from trees during an aerial application maneuver. Factors were the trees at the perimeter of the field, and the gusting tail wind conditions at the time of the accident.Jul 16, 1994 · N5657J · Substantial damageNTSB ANC94LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Talkeetna, AKThe pilot misjudged clearance from a bush.Jul 16, 1994 · N6066D · Substantial damageNTSB ANC94LA083Accident · No injuriesLimited investigationFinal reportCessna 206 · Noatak, AKThe pilot's selection of unsuitable landing area. A factor was a 'cut bank' in the landing area.Jul 16, 1994 · N8287Q · Substantial damageNTSB ANC94LA082Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKThe pilot did not use the takeoff checklist to confirm that the flaps were extended for the takeoff.Jul 16, 1994 · N2297R · Substantial damageNTSB SEA94LA185Accident · No injuriesLimited investigationFinal reportCessna A152 · Bremerton, WAThe pilot's failure to maintain directional control.Jul 15, 1994 · N761UA · Substantial damageNTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.Jul 15, 1994 · N1540A · Substantial damageNTSB NYC94LA129Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Stevensville, MDInadequate maintenance by which undertorquing of the accessory gear retaining bolt resulted in fatigue failure of the bolt and the subsequent loss of engine power.Jul 15, 1994 · N515TN · Substantial damageNTSB MIA94FA179Accident · 1 fatalField investigationFinal reportCessna 172XP · Indian Shores, FLA bird collision, which resulted in pilot incapacitation.Jul 15, 1994 · N2827V · DestroyedNTSB FTW94MA236Accident · Serious injuriesMajor investigationFinal reportAerospatiale AS350B · Kalaupapa, HIThe pilot's failure to properly monitor power required versus power available to maintain rotor revolutions per minute (RPM), resulting in rotor RPM decay and a forced landing. Factors related to the accident were: the pilot's change of the tour route without…Jul 15, 1994 · N350MH · Substantial damageNTSB FTW94MA235Accident · 3 fatalMajor investigationFinal reportAerospatiale AS350D · Hanalei, HIFailure of the engine-driven fuel pump, which resulted in the loss of power, and the lack of aircraft flotation equipment. Factors related to the accident were: flight over water adjacent to terrain that afforded no suitable forced landing site, and the lack…Jul 15, 1994 · N151BH · Substantial damageNTSB FTW94LA238Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARThe loss of power due to the number one cylinder head cracking. A factor was the lack of suitable terrain for the forced landing.Jul 15, 1994 · N4903X · Substantial damageNTSB CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.Jul 15, 1994 · N8512C · Substantial damageNTSB CHI94LA232Accident · No injuriesLimited investigationFinal reportCessna 180 · Battle Lake, MNloss of engine power due to fuel exhaustion which resulted from inaccurate fuel consumption calculations. A factor related to the accident was the inaccurately placarded fuel tanks.Jul 15, 1994 · N333QB · Substantial damageNTSB ATL94LA139Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Dobson, NCThe vehicle driver's failure to remain clear of a runway in use.Jul 15, 1994 · N70BL · Substantial damageNTSB FTW94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Tulsa, OKThe loss of engine power for undetermined reasons. The lack of terrain suitable for a forced landing was a factor.Jul 14, 1994 · N5193W · Substantial damageNTSB FTW94FA233Accident · 2 fatalField investigationFinal reportCessna 310Q · Greenville, TXThe cfi's failure to maintain airspeed above VMC, resulting in a loss of control during the single engine G0-around. Factors were not attaining runway alignment and the cfi's failure to retract the landing gear for the go-around procedure.Jul 14, 1994 · N310AE · DestroyedNTSB ATL94LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greenville, SCThe pilot's improper positioning of the fuel selector valve which resulted in fuel starvation.Jul 14, 1994 · N21380 · Substantial damageNTSB SEA94LA178Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Easton, WAImproper planning/decision by the pilot-in-command, and inadequate supervision by the check pilot, which resulted in their failure to remain clear of trees during takeoff. Factors related to the accident were: a downdraft and the proximity of trees to the…Jul 13, 1994 · N65857 · Substantial damageNTSB SEA94LA161Accident · No injuriesLimited investigationFinal reportCessna 140 · Kent, WAInadequate compensation for wind conditions. A factor to the accident was wind gust.Jul 13, 1994 · N77045 · Substantial damageNTSB NYC94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lancaster, OHThe loss of engine power for undetermined reasons.Jul 13, 1994 · N800CE · DestroyedNTSB NYC94FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Trout Run, PAthe delayed decision of the pilot to deviate from known weather which resulted in an inflight loss of control and impact with terrain.Jul 13, 1994 · N3150E · DestroyedNTSB NYC94FA123Accident · No injuriesField investigationFinal reportGates Learjet 35 · Atlantic City, NJUnder-inflation of the tires, due to improper maintenance, which resulted in overheating and subsequent tire failure; the incorrect checklist that was provided to the aircrew; and failure of the pilot-in-command to deploy the drag chute, when the thrust…Jul 13, 1994 · N69PS · Substantial damage