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 LAX89LA166Accident · No injuriesLimited investigationFinal reportWaco QCF · Hollbrook, AZThe pilot's failure to maintain directional control of the airplane due to gusting wind conditions. The pilot did not adequately correct the situation before the airplane traveled into soft terrain.NTSB FTW89LA080Accident · No injuriesLimited investigationFinal reportCessna 182Q · Leakey, TXThe pilot's improper compensation for wind conditions, improper flare, and improper recovery from a bounced landing. Factors related to the accident were: the gusty wind condition and the pilot's lack of experience in this make and model of aircraft.NTSB SEA89LA073Accident · No injuriesLimited investigationFinal reportDonner/Parton Avid Flyer · Stanwood, WAAn ignition lead became disconnected from one cylinder, which resulted in a partial power loss. A factor related to the accident was: soft terrain in the touchdown area.NTSB SEA89LA072Accident · No injuriesLimited investigationFinal reportBeech A55 · Arlington, WAA premature/improper retraction of the landing gear by the second pilot (aircraft owner), who was occupying the right front seat.NTSB LAX89FA165Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Stockton, CAPoor judgement of the pilot by flying while physically impaired from consumption of alcohol & drugs, and his failure to maintain proper altitude. The light condition (at night) and the obstructions (power lines and building) were considered to be contributing…NTSB SEA89FA074Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Pelican, AKImproper in-flight decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). The terrain and weather conditions were considered to be factors.NTSB NYC89LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Gettysburg, PAThe pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion.NTSB NYC89FA121Accident · 1 fatalField investigationFinal reportBeech B19 · Augusta, MEFailure of the pilot to maintain the proper altitude during the approach. A factor related to the accident was: the pilot's psychological condition.NTSB FTW89DRA04Accident · No injuriesFinal reportAir Tractor AT-502 · Ganado, TXLoss of directional control for an unknown reason.NTSB DEN89LA111Accident · No injuriesLimited investigationFinal reportCessna 170A · Kalispell, MTThe pilot's failure to maintain control of the airplane during the landing flare and rollout. Contributing to the accident was the pilot's lack of proficiency with only 4 hours of flight time in the preceding 90 day period.NTSB DEN89LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe pilot's failure to compensate for the wind conditions during the takeoff. Contributing to the accident were the crosswind conditions.NTSB BFO89LA030Accident · No injuriesLimited investigationFinal reportCessna 150F · New Cumberland, WVThe pilot's failure to compensate for crosswind conditions during an attempted go-around. Contributing factors were the crosswind condition and the pilot's low level of experience.NTSB MKC89LA092Accident · No injuriesLimited investigationFinal reportVestal Quickie Q2 · St Joseph, MOThe pilot's improper flare and failure to maintain directional control of the aircraft. A factor related to the accident was: the pilot's lack of experience in this make and model of aircraft.NTSB LAX89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fresno, CAThe pilot's inflight decision to abort the takeoff and land in a field. Contributing to the accident was the fence post that the aircraft collided with during the landing roll.NTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB NYC89LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · So. Bethlehem, NYThe pilots misjudgement of landing distance which resulted in the failure to touchdown at a proper touchdown point. The pilot also failed to perform a go-around.NTSB MIA89TL#04Accident · Minor injuriesClass 3Final reportBell 206B · Ochopee, FLNTSB MIA89LA133Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Miami, FLThe unqualified persons failure to maintain clearance from the fence. Pressure induced by others, lack of experience, and over confidence in personal ability are contributing factors to this accident.NTSB FTW89LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Athens, TXFuel exhaustion due to inadequate preflight by the pilot.NTSB FTW89FA151Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Junction, TXContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, which resulted in his failure to maintain control of the aircraft due to spatial disorientation. The weather conditions and his self-induced pressure were factors.NTSB DEN89LA109Accident · No injuriesLimited investigationFinal reportCessna 310E · Glenwood Spgs, COInadequate compensation for the wind conditions by the pilot, resulting in a loss of control of final approach. Contributing to the accident was the downdraft.NTSB CHI89TL#02Accident · No injuriesClass 3Final reportBellanca Bgcbc · Shell Lake, WINTSB ATL89FA130Accident · Serious injuriesField investigationFinal reportBell UH-1E · Aiken, SCImproper installation of a tail rotor pitch change crosshead retention bolt by the company mechanic, which resulted in loosening of the bolt and eventual failure of the tail rotor assembly/blade and subsequent loss of control. Trees at the crash site…NTSB ANC89LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.NTSB MIA89FA132Accident · 1 fatalField investigationFinal reportCoutz Quickie Q-2 · Lake City, FLAircraft control was lost for an unknown reason.NTSB LAX89LA162Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe pilots improper use of carburetor heat in conditions that were conducive to the formation of carburetor ice.NTSB FTW89FA081Accident · Serious injuriesField investigationFinal reportHead Balloons AX8-88 · Troy, TXImproper planning/decision by the pilot, and inadequate supervision by the check pilot, which resulted in their failure to maintain clearance from the tree during the landing. Factors related to the accident were: the high wind & tree(s).NTSB SEA89LA070Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4 · Yamhill, ORPilot displayed poor inflight planning and preparation for the flight. The pilot did not adequately compensate for the wind conditions resulting in an intentional gear up landing.NTSB NYC89LA118Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · W.Mifflin, PAThe improper level off of the aircraft by the pilot which resulted in a hard landing and subsequent gear collapse.NTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.NTSB MIA89LA131Accident · No injuriesLimited investigationFinal reportCessna 182P · Tavernier, FLFailure of the pilot to maintain runway alignment and retract the flaps to the recommended setting during the go-around.NTSB LAX89LA161Accident · No injuriesLimited investigationFinal reportCessna 175 · Victorville, CAThe pilot's failure to conduct an adequate preflight and assure the proper quantity of fuel on board for the proposed flight.NTSB LAX89FA160Accident · Minor injuriesField investigationFinal reportSikorsky S-58ET · Santa Ana, CAFailure of the landing gear resulting from excessive loading during ground operations, and fatigue cracking.NTSB FTW89LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXThe inadequate aircraft handling by the student pilot, where she allowed the airplane to start to porpoise, and then did not correct it.NTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…NTSB CHI89DET04Accident · 1 fatalFinal reportAmerican AA-1A · Bluffton, INInadequate airspeed resulting in a stall/spin by the pilot. Factors related to the accident were: a tailwind and wrong runway selected by the pilot.NTSB BFO89FA027Accident · 1 fatalField investigationFinal reportCessna 152 · West Chicago, ILImproper instruction by the student's flight instructor regarding the execution of s-turns on final approach to increase spacing and the retraction of flaps fully when executing a go-around and the failure of the student pilot to maintain adequate flying…NTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…NTSB ATL89FA131Accident · 2 fatalField investigationFinal reportMooney M20F · Lynch, KYContinued VFR flight by the pilot into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions, terrain, and the pilot's lack of instrument experience.NTSB SEA89LA086Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355-F2 · Las Vegas, NVThe pilot's poor inflight decision in selecting an unsuitable area for practice landings and the pilot's inadequate visual lookout resulting in a tail rotor strike and loss of antitorque control.NTSB SEA89LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arlington, ORThe student pilot touched down too FAR down the runway to allow him to stop before running into a trailer.NTSB NYC89LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Palmyra, PAThe pilot misjudged the airspeed and distance during the landing.NTSB MKC89FA090Accident · 2 fatalField investigationFinal reportPiper J-3 · Oak Grove, MOThe pilot's attempt to takeoff with the aircraft over its allowable takeoff weight and out of the center of gravity limits.NTSB LAX89LA169Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bolinas, CAThe pilot's poor preflight planning in that he did not accurately account for the fuel on board the aircraft as a basis for fuel consumption calculations thereby causing the engine to stop producing power because of a lack of fuel. Contributing to the…NTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.NTSB ANC89IA059Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-6-100 · Barrow, AKThe propagation of a fatigue crack from multiple origins due to manufacturing defects in the elevator bellcrank mounting quadrant.NTSB NYC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Matawan, NJThe pilot's inadequate action after encountering tailwind conditions during landing.NTSB MKC89LA089Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARImproper planning/decision by the pilot, and his misjudgement of clearance between the airplane, wires, and the ground during the aerial application maneuver. Factors relating to the accident were: the dirty windshield, sunglare, transmission line (wires),…NTSB MIA89LA130Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Lakeland, FLThe pilot's failure to maintain directional control, which resulted in an inadvertent ground loop.NTSB MIA89LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Pierce, FLFailure of the number five cylinder. Factors related to the accident were: the proximity of homes in the area, which precluded jettisoning of the chemical load, and high vegetation in the emergency landing area.