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 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.NTSB 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…NTSB 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.NTSB 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…NTSB FTW94LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Marianna, ARA premature liftoff. Factors were the tall, wet grass and a tail wind component.NTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB ANC94LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's failure to maintain directional control.NTSB 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.NTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.NTSB SEA94LA183Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Pilot Rock, ORDirectional control was not maintained for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX94LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elko, NVthe pilots attempted takeoff with a strong and gusty tailwind.NTSB 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.NTSB 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.NTSB CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.NTSB 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.NTSB 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.NTSB ANC94LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Talkeetna, AKThe pilot misjudged clearance from a bush.NTSB 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.NTSB 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.NTSB SEA94LA185Accident · No injuriesLimited investigationFinal reportCessna A152 · Bremerton, WAThe pilot's failure to maintain directional control.NTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.NTSB 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.NTSB MIA94FA179Accident · 1 fatalField investigationFinal reportCessna 172XP · Indian Shores, FLA bird collision, which resulted in pilot incapacitation.NTSB 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…NTSB 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…NTSB 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.NTSB CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.NTSB 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.NTSB ATL94LA139Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Dobson, NCThe vehicle driver's failure to remain clear of a runway in use.NTSB 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.NTSB 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.NTSB ATL94LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greenville, SCThe pilot's improper positioning of the fuel selector valve which resulted in fuel starvation.NTSB 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…NTSB SEA94LA161Accident · No injuriesLimited investigationFinal reportCessna 140 · Kent, WAInadequate compensation for wind conditions. A factor to the accident was wind gust.NTSB NYC94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lancaster, OHThe loss of engine power for undetermined reasons.NTSB 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.NTSB 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…