NTSB investigations, 2020
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 WHERE year(c.\"eventDate\") = 2020 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 WHERE year(c."eventDate") = 2020 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 CEN20LA373Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA24 · Midland, MIThe loss of engine power due to fuel starvation.NTSB WPR20CA312Accident · No injuriesClass 4 · Data collectionFinal reportBeechcraft C90A · Fortuna, CAA collision with a deer while landing at night.NTSB ERA20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA20 · Luray, VAThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.NTSB ANC20LA086Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA 14 · Wasilla, AKThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions, which resulted in impact with trees.NTSB GAA20WA133Accident · 4 fatalForeign investigationCommander 114 · Fur airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a COMMANDER 114 airplane that occurred on August 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…NTSB ERA20CA300Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Millington, MDThe pilot’s misidentification of a corn field for the destination airport’s runway, and a subsequent aerodynamic stall at low altitude while attempting to land.NTSB CEN20LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper J3 · Hartford, WIThe pilot’s loss of situation awareness which resulted in landing in a grass area and the subsequent collision with a runway marker.NTSB CEN20LA372Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 414 · Ray, MIThe pilot’s loss of directional control on takeoff.NTSB CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.NTSB ANC20CA091Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Lime Village, AKThe pilot’s loss of control during the landing flare, which resulted in an impact with trees.NTSB ERA20CA303Accident · No injuriesClass 4 · Data collectionFinal reportZenith CH601 · Punta Gorda, FLAn inadvertent opening of the airplane’s canopy on takeoff, which resulted in a loss of control and runway excursion.NTSB DCA20WA142Accident · No injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13.All…NTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…NTSB WPR20WA294Accident · No injuriesForeign investigationBell 206 · Lago, NigeriaThe government of Nigeria has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Nigeria's investigation under the provisions…NTSB WPR20LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TU206 · Tusayan, AZA total loss of engine power due to fuel starvation as a result of contamination in the airplane’s fuel system.NTSB GAA20WA134Accident · 1 fatalForeign investigationBeech 35 · Teresina, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 35 airplane that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ERA20LA297Accident · 2 fatalClass 3 · LimitedFinal reportRockwell 500 · Pembroke Park, FLA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the fatigue fracture of an electrical wire in the tank unit or fuel transmitter, which likely resulted in an inaccurate fuel quantity indication.NTSB ERA20CA304Accident · No injuriesClass 4 · Data collectionFinal reportTecnam P92 · Charlottesville, VAThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB DCA20WA140Accident · No injuriesClass 5 · ForeignBoeing 767 · Bucure?ti, RomaniaNTSB WPR20LA289Accident · 2 fatalClass 3 · LimitedFinal reportBeech A36 · Redding, CAThe pilot’s failure to recognize the airplane’s inadequate takeoff performance given the length of the available runway and to abort the takeoff, which resulted in a runway excursion.NTSB ERA20LA302Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Fletcher, NCA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA20LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Weston, FLA total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.NTSB ERA20CA298Accident · Minor injuriesClass 4 · Data collectionFinal reportVans RV6 · Milton, DEThe pilot and owner’s failure to adequately communicate and establish an understanding of who was flying the airplane, and their failure to take timely action to avoid a collision with terrain.NTSB CEN20CA366Accident · Minor injuriesClass 4 · Data collectionFinal reportJewett SC-360 · Brighton, COThe pilot’s excessive application of wheel brakes during the landing roll that caused the airplane to nose over.NTSB ANC20LA085Accident · 2 fatalClass 3 · LimitedFinal reportCessna A185 · Fairbanks, AKThe PA-18 pilot’s failure to see and avoid the Cessna 185 as it was landing. Contributing to the accident was the PA-18 pilot’s failure to hear the traffic advisory provided by the air traffic control tower.NTSB WPR20WA292Accident · 1 fatalForeign investigationCessna 172 · Springs, South AfricaThe government of South Africa has notified the National Transportation Safety Board (NTSB) of an accident involving a Cessna 172 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB WPR20LA288Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chino, CAThe failure of the engine-driven hydraulic pump, which resulted in the main landing gear not fully extending and locking into place during landing. Contributing to the accident was the failure of the emergency gear extension system for reasons that could not…NTSB GAA20WA132Accident · 2 fatalClass 5 · ForeignAviamilano Falco F8L · Sibari, ItalyNTSB DCA20WA139Incident · No injuriesForeign investigationDouglas DC3 · San Jose del Guaviere, ColombiaThe GRIAA of Colombia has notified the NTSB of an incident involving a Douglas (Boeing) DC3 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA of Colombia's investigation under the provisions…NTSB CEN20WA435Accident · 2 fatalClass 4 · ForeignSchleicher ASH25 · Gloucestershire, United KingdomNTSB CEN20LA365Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210 · Peyton, COThe pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.NTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.NTSB WPR20LA283Accident · 1 fatalClass 3 · LimitedFinal reportKaman K 1200 · Pine Grove, ORAn in-flight breakup resulting from contact of the left rotor system with the right rotor system after an in-flight failure of a servo flap from a left rotor blade.NTSB WPR20CA297Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Givens Hot Springs, IDPilot's failure to maintain directional control on takeoff.NTSB ANC20LA083Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS350 · Ninilchik, AKA loss of engine power for an undetermined reason.NTSB WPR20CA286Accident · No injuriesClass 4 · Data collectionFinal reportNorthrop F5 · Reno, NVThe pilot's failure to complete the pre-landing checklist due to a distraction which resulted in a gear-up landing.NTSB WPR20CA284Accident · No injuriesClass 4 · Data collectionFinal reportBell 205 · LaVerne, CAThe pilot’s delayed decision to initiate a go-around while landing in an unimproved area which resulted in a collision with debris.NTSB GAA20WA141IncidentClass 5 · ForeignRobinson R44 · Gulf of Glyfada, GreeceNTSB ERA20CA296Accident · No injuriesClass 4 · Data collectionFinal reportBeech 55 · Nashville, TNThe pilot's inadvertent feathering of the propellers during the landing flare, which resulted in a hard landing. A factor in the accident was the instructor's failure to fully monitor the pilot's manipulation of the levers in the airplane's non-standard…NTSB DCA20WA141Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 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 CEN20LA364Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Ogallala, NEThe total loss of engine power due to a failure of the master connecting rod.NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.NTSB CEN20CA371Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Willoughby, OHThe student pilot’s improper landing flare that resulted in a porpoise and collapsed nose landing gear.NTSB CEN20CA362Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Lebanon, MOThe pilot's failure to maintain directional control during landing.NTSB WPR20CA287Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Tok, AKThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.NTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.NTSB ERA20CA294Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB200 · Simsbury, CTA runway excursion following an aborted takeoff in tailwind conditions.NTSB CEN20LA360Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · St Louis, MOA total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.NTSB CEN20CA363Accident · No injuriesClass 4 · Data collectionFinal reportBeech 55 · Athens, TXThe pilot’s failure to extend the landing gear during the approach and landing.NTSB ANC20CA088Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Kotzebue, AKThe pilot's failure to maintain an airspeed conducive to flight during takeoff.