NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WPR19LA098Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 24 · Reno, NVFailure of the engine mount due to internal corrosion and wall thinning, which resulted in a loss of directional control and nose gear collapse during landing.NTSB WPR19LA097Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Newberg, ORThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN19FA100Accident · 1 fatalClass 2 · FieldFinal reportCessna 421 · Plain City, OHA loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.NTSB WPR19FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech 50 · Riverside, CAThe pilot’s failure to maintain airspeed and control of the airplane following a loss of right engine power for reasons that could not be determined based on the available information.NTSB ANC19LA015Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Talkeetna, AKA loss of pitch control for an undetermined reason, which resulted in a collision with terrain during an emergency landing.NTSB WPR19LA114Accident · No injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1A-2 · San Diego, CAThe fracture of the aileron hinge strap due to fatigue crack propagation, which resulted in substantial damage to a wing rib aft of the spar at the outboard aileron cutout. Contributing to the accident was inadequate maintenance inspection.NTSB GAA19CA173Accident · Minor injuriesData collectionFinal reportPereira Osprey · Independence, IAThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA19CA170Accident · No injuriesData collectionFinal reportPiper PA 11 · Moberly, MOThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA19CA169Accident · No injuriesData collectionFinal reportCessna 152 · Madras, ORThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a collision with a snow berm and a subsequent nose-over.NTSB GAA19CA167Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Yakima, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop, and the flight instructor's delayed remedial action.NTSB DCA19WA131Incident · No injuriesForeign investigationBoeing 737 · Jogyakarta, IndonesiaThe KNKT of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB WPR19FA095Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28 · Compton, CAThe failure of the T-28 pilot to see and avoid the Cessna while landing with reduced visibility due to sun glare, which resulted in a collision on the runway. Contributing to the accident was his failure to use the airport's common traffic advisory frequency…NTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.NTSB ERA19FA130Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Cashiers, NCThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB CEN19FA099Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Lakeway, TXA partial loss of engine power for reasons that could not be determined, and the flight instructor's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing, which resulted in an aerodynamic stall and subsequent loss of…NTSB GAA19CA168Accident · No injuriesData collectionFinal reportHughes TH 55 · Keene, NHThe helicopter’s collision with a bird during cruise flight.NTSB ERA19TA129Accident · No injuriesClass 3Final reportBeech E55 · St. Petersburg, FLThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA19LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Brevard, NCThe mechanic's failure to notice that the left front seat left front roller housing disengaged from the seat rail during recent maintenance, and the pilot's failure to detect the disengaged roller housing during the preflight inspection, which resulted in the…NTSB ERA19LA126Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Ponte Vedra Beach, FLA total loss of engine power due to the introduction of air into fuel lines and an interruption of fuel flow to the engine.NTSB GAA19CA165Accident · No injuriesData collectionFinal reportCirrus SR20 · Akron, COThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a drainage culvert.NTSB ERA19LA123Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · Latrobe, PAA landing gear collapse due to the separation of the actuator pinion bearing support from the actuator, which resulted in the failure of the actuator shaft.NTSB ERA19FA124Accident · 1 fatalField investigationFinal reportPiper PA31 · Madeira, OHFuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.NTSB CEN19LA098Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32R · Waterloo, ILThe loss of engine power due to a connecting rod failure for reasons that could not be determined due to secondary mechanical damage, which resulted in a subsequent forced landing.NTSB GAA19WA222Accident · 2 fatalForeign investigationCessna U206 · Bolivar, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB GAA19WA175Accident · 1 fatalForeign investigationCessna 188 · Rio Pardo, State of Rio Grande do sul, Brazil, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 188 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB GAA19CA172Accident · No injuriesData collectionFinal reportCessna 172 · Oskaloosa, IAThe student pilot's failure to maintain directional control during landing with a left quartering tailwind, which resulted in a runway excursion, impact with a snowbank, and a nose-over.NTSB GAA19CA163Accident · No injuriesData collectionFinal reportAir Tractor AT 400A · Parma, IDThe pilot's failure to maintain directional control during landing in variable wind conditions, which resulted in the right wing impacting muddy terrain.NTSB GAA19CA161Accident · Minor injuriesData collectionFinal reportCessna L19 · Benton, KSThe pilot's receiving instruction’s failure to maintain directional control during the landing roll, which resulted in impact with trees and a house.NTSB DCA19CA105Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Atlanta, GAfailure of the B737 captain to maintain separation with the airplane stopped on the taxiway.NTSB DCA19RA101Accident · 157 fatalForeign investigationBoeing 737 · Addis Ababa, EthiopiaThe government of Ethiopia has notified the NTSB of an accident involving a BOEING 737 that occurred on March 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ethiopia's investigation under the provisions of ICAO…NTSB DCA19CA102Accident · Minor injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCfailure of the ground crew to maintain visual separation and avoid the holding aircraft.NTSB CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, GuatemalaNTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB GAA19CA171Accident · No injuriesData collectionFinal reportCessna T210 · Chandler, AZThe pilot's distraction while looking for other aircraft in the traffic pattern, which resulted in his failure to follow a prelanding checklist and to extend the landing gear before landing. Contributing to the accident was the improperly rigged landing gear…NTSB GAA19CA166Accident · Minor injuriesData collectionFinal reportCessna 177RG · Land O' Lakes, WIThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA19CA159Accident · Minor injuriesData collectionFinal reportPiper PA18 · Pullman, WAThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB ERA19WA121Accident · 14 fatalForeign investigationDouglas DC3 · Vereda La Bendicion, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB ERA19TA122Accident · No injuriesClass 3Final reportGulfstream GIV · Chamblee, GAThe flight crew’s incorrect glidepath and flare to landing, which resulted in a landing area undershoot and the main landing gear’s collision with the runway threshold.NTSB ERA19LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Mount Holly, NJFailure of the pilot's seat back due to a sheared bolt during the landing roll, which resulted in a loss of directional control and runway excursion.NTSB DCA19WA114Incident · No injuriesForeign investigationBoeing 747 · Taiwan, TaiwanAviation Safety Council of Taiwan has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Taiwan's investigation under the…NTSB CEN19FA094Accident · 4 fatalField investigationFinal reportCessna T337 · Longview, TXThe noninstrument-rated pilot's improper decision to continue flight into convective weather conditions, which resulted in the airplane exceeding its maximum maneuvering speed and the subsequent in-flight breakup. Contributing to the accident was the pilot's…NTSB WPR19FA093Accident · 5 fatalClass 2 · FieldFinal reportPiper PA23 · Pahokee, FLThe pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19FA091Accident · 1 fatalClass 2 · FieldFinal reportBell UH1B · Forks, WAA total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…NTSB GAA19CA160Accident · No injuriesData collectionFinal reportPiper PA18 · Rushville, NEThe partial loss of engine power due to the accumulation of carburetor ice, which resulted in a forced landing on rough terrain.NTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.NTSB GAA19CA158Accident · No injuriesData collectionFinal reportPiper PA18 · Wyndmere, NDThe pilot's exceedance of the airplane's critical angle of attack during an uncoordinated turn while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB GAA19CA157Accident · No injuriesData collectionFinal reportPiper PA22 · Superior, WIThe pilot's failure to maintain directional control during landing on a snow- and ice-covered runway, which resulted in impact with a snowbank and a nose-over.NTSB GAA19CA156Accident · No injuriesData collectionFinal reportJames A Gray Just Aircraft · Marysville, OHThe student pilot's improper landing flare, which resulted in a hard, bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and ground loop.NTSB ENG19WA020Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 7, 2019. A GoAir Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure while…