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 ERA20CA073Accident · No injuriesData collectionFinal reportBeech Hawker 900XP · San Juan, PRThe pilot's failure to maintain a proper descent rate during landing, which resulted in a hard landing short of the runway.NTSB CEN20WA054Accident · 4 fatalForeign investigationMooney M20 · Lifou Wanaham, New CaledoniaOn January 3, 2020, about 1430 universal coordinated time, a Mooney M20J, French registration F-OIAT, impacted terrain shortly after departing the Lifou Wanaham Airport (New Caledonia). The aircraft was destroyed, and the pilot and three passengers were…NTSB WPR20CA069Accident · Serious injuriesData collectionFinal reportGulfstream G IV · Van Nuys, CAThe airplane’s encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB ERA20LA064Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Kenansville, NCA fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.NTSB DCA20WA084Incident · No injuriesForeign investigationBoeing 757 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 757 airplane that occurred on January 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20LA053Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Ada, OKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation, and the pilot’s inadequate preflight inspection and preflight fuel planning.NTSB ANC20CA011Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Fairbanks, AKThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency off-airport landing, and a nose over.NTSB WPR20CA055Accident · No injuriesData collectionFinal reportCessna 175 · Elk, CAThe pilot's failure to arrest the descent rate during an aborted simulated engine-out approach, which resulted in impact with vegetation and a subsequent cartwheel.NTSB CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.NTSB CEN20FA049Accident · 2 fatalClass 3 · FieldFinal reportMooney M20S · Olathe, KSThe pilot’s failure to set the elevator trim properly for takeoff, which resulted in an exceedance of the airplane’s critical angle of attack during climb out, an aerodynamic stall, and the subsequent impact with terrain.NTSB CEN20CA052Accident · No injuriesData collectionFinal reportPiper PA28R · Onaga, KSThe pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.NTSB WPR20LA054Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU2B · Big Piney, WYThe failure of the right propeller position to correspond to the throttle change when moved to the beta position for reasons that could not be determined based on available evidence.NTSB ERA20WA061Accident · 3 fatalForeign investigationPiper PA-32-301T · Vereda Cuzama, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA-32-301T airplane that occurred on December 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN20CA048Accident · No injuriesData collectionFinal reportVans RV 10 · Granbury, TXThe airplane’s impact with a bird while on approach.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB ERA20FA060Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA5 · College Park, MDThe pilot's loss of airplane control due to spatial disorientation after entering a climbing turn in instrument meteorological conditions.NTSB CEN20WA061Accident · No injuriesForeign investigationRobinson R44 · Wijnendaele, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on December 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the…NTSB WPR20CA053Accident · No injuriesData collectionFinal reportCessna 170 · Missoula, MTThe pilot receiving instruction's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop, and the flight instructor’s failure to adequately monitor the pilot.NTSB ERA20WA067Accident · No injuriesForeign investigationCessna 560 · Cmte Nicanor Otamendi, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA 560XLS airplane that occurred on December 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB ERA20LA082Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Farmingdale, NYThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA20LA062Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Fletcher, NCA failure of two of the oil pump drive gear’s teeth, which resulted in a loss of engine oil lubrication, and a total loss of engine power.NTSB CEN20MA044Accident · 5 fatalClass 2 · MajorFinal reportPiper PA 31T · Lafayette, LAThe pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.NTSB WPR20FA051Accident · No injuriesClass 3 · FieldFinal reportCirrus SF50 · Santa Monica, CAThe improper design of the audio interface system, which caused an electrical short circuit that led to a ground fire.NTSB CEN20WA126Accident · No injuriesForeign investigationCessna 152 · San Salvador, El SalvadorOn December 27, 2019, about 0730 local time, a Cessna 152 airplane, YS-162PE, impacted terrain near San Salvador, El Salvador, and was destroyed. The two occupants were not injured. The accident investigation is under the jurisdiction and control of the…NTSB ANC20MA010Accident · 7 fatalClass 1 · MajorFinal reportAirbus AS350B2 · Kekaha, HIThe pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…NTSB ERA20CA078Accident · No injuriesData collectionFinal reportCessna 172 · Ormond Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA20FA056Accident · 1 fatalClass 3 · FieldFinal reportBell 407 · Headland, ALPilot incapacitation by a sudden cardiac event related to severe coronary artery disease, which resulted in a loss of helicopter control.NTSB GAA20WA101Accident · 1 fatalForeign investigationPiper PA25 · Rio Branco, Cerro Largo, UruguayThe government of Uruguay has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Uruguay's investigation under the provisions…NTSB ERA20LA080Accident · No injuriesClass 3 · LimitedFinal reportTeam Rocket F-1 F-1 · Suffolk, VAA structural failure of the horizontal stabilizer during aerobatic maneuvers near the airplane’s never-exceed speed. Contributing to the failure was the construction of the horizontal stabilizer that did not meet the kit manufacturer’s specifications.NTSB ERA20LA070Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Concord, NCA malfunction of the left main landing gear brake during landing for undetermined reasons. Contributing was the pilot’s failure to attain a proper touchdown point and maintain an appropriate approach speed while landing on the wet turf runway.NTSB ERA20CA110Accident · Minor injuriesData collectionFinal reportPiper PA28 · Cortland, NYThe student pilot's failure to maintain the runway heading during takeoff, which resulted in impact with a snowbank and a subsequent nose-over.NTSB DCA20WA044Incident · No injuriesForeign investigationBoeing 737 · Manchester, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB CEN20WA045Accident · No injuriesForeign investigationCessna 208 · San Rafael, MexicoOn December 24, 2019, about 1529 coordinated universal time, a Cessna 208B airplane, XA-TWN, impacted desert terrain near San Rafael, Sonoroa, Mexico, while enroute to the Guerrero Negro Airport (MMGR), Baja California, Mexico. The two occupants sustained…NTSB WPR20CA052Accident · No injuriesData collectionFinal reportPiper PA28 · Chandler, AZThe student pilot's loss of directional control during the landing roll, which resulted in a collision with a taxiway sign.NTSB ERA20CA111Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Hanson, MAThe flight instructor's delayed remedial action, which resulted in his decision to perform an off field landing and the airplane's subsequent impact with terrain.NTSB ENG20WA019Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · New Chitose Airport (RJCC), JapanNTSB ENG20WA011Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 23, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an inflight shutdown…NTSB DCA20LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-824 · Denver, COMaintenance personnel’s excessive grinding of the left main landing gear’s aft trunnion pin during its initial overhaul, which caused heat damage to the base metal and led to the fatigue crack that caused the pin to fail during the accident flight.…NTSB CEN20CA059Accident · No injuriesData collectionFinal reportZenith CH 750 · Xenia, OHThe pilot’s failure to maintain airplane control during landing, which resulted in the right tire contacting the runway first followed by the left wing.NTSB CEN20CA040Accident · Minor injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot's failure to attain an adequate climb rate during an aborted landing with a left quartering, gusting headwind, which resulted in impact with a tree.NTSB WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.NTSB WPR20CA056Accident · Serious injuriesData collectionFinal reportCosmos Phase II · Lake Havasu City, AZThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel inspection.NTSB ERA20CA059Accident · Minor injuriesData collectionFinal reportEipper Quicksilver · Mayaguez, PRThe student pilot's inadvertent movement of the fuel shutoff switch to the “off” position while attempting to take a picture of himself, which resulted in a total loss of engine power due to fuel starvation and a subsequent ditching in open water.NTSB ENG20WA009Incident · No injuriesForeign investigationAirbus A320 · Mumbai, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 22, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced high engine…NTSB DCA20CA050Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Kansas City, MOa bird strike during descentNTSB GAA20WA104Accident · 2 fatalForeign investigationCirrus SR22 · Salzburg, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the…NTSB ERA20CA058Accident · Minor injuriesData collectionFinal reportCessna P210 · Gainesville, FLThe airplane's impact by a bird during the initial climb.NTSB CEN20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Rush City, MNThe total loss of engine power due to fuel starvation because the student pilot failed to reposition the fuel mixture control to full rich before takeoff.NTSB CEN20FA038Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Evansville, INThe pilot’s failure to maintain control of the airplane.NTSB ERA20LA057Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Florida, MAThe pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation and a forced landing in a remote, wooded terrain.