NTSB investigations, 2020
31 cases where the defining event was Miscellaneous/other.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 27 |
| 2010 | 39 |
| 2011 | 52 |
| 2012 | 66 |
| 2013 | 48 |
| 2014 | 41 |
| 2015 | 39 |
| 2016 | 56 |
| 2017 | 42 |
| 2018 | 54 |
| 2019 | 36 |
| 2020 | 31 |
| 2021 | 18 |
| 2022 | 27 |
| 2023 | 28 |
| 2024 | 33 |
| 2025 | 54 |
| 2026 | 22 |
Where
Open the mapLatest cases
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
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900')
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 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 WPR21LA061Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Arch Cape, ORThe pilot’s descent into the ocean for reasons that could not be determined.NTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.NTSB ANC20CA097Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Arctic Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a rock damaging the empennage.NTSB DCA21WA065IncidentClass 5 · ForeignBoeing 737 · Khartoum, SudanNTSB DCA20WA144Incident · No injuriesForeign investigationBoeing 737 · West Midland, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB ERA20LA310Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Fort Myers, FLForeign object damage of the turning tailrotor by a soft-bodied object, which resulted in the sudden stoppage of the tailrotor and the catastrophic failure of the tailrotor assembly and its mount structure.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 CEN20CA348Accident · No injuriesClass 4 · Data collectionFinal reportProgressive Aerodyne Searey · League City, TXThe pilot's failure to maintain airplane control during a water takeoff after an encounter with the wake from a boat.NTSB CEN20CA337Accident · Serious injuriesClass 4 · Data collectionFinal reportEvektor Aerotechnik L13 · Frankenmuth, MIThe pilot's failure to stow the speed brake prior to attempting takeoff.NTSB WPR20LA278Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Harlowton, MTThe pilot’s failure to follow the appropriate takeoff procedures, which resulted in a collision with terrain.NTSB ERA20LA288Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170 · Ardmore, TNThe pilot’s inadequate preflight planning and his decision to depart from a constrained, grass-covered field in elevated-density altitude conditions, which resulted in reduced takeoff and climb performance and a subsequent forced landing.NTSB CEN20CA334Accident · No injuriesClass 4 · Data collectionFinal reportHughes 369 · Delia, KSForeign object damage sustained to the main rotor blades due to aerial tree trimming.NTSB CEN20CA320Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna A188 · Memphis, MOThe pilot did not remove the rudder gust lock during the preflight inspection, which resulted in a forced landing and collision with a tree.NTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…NTSB ANC20CA068Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Ketchikan, AKThe crew leader's decision to throw a chainsaw bar into the moving arc of the main rotor blade.NTSB CEN20LA264Accident · No injuriesClass 3 · LimitedFinal reportMbb BK117 · Wooster, OHThe entanglement of construction fencing into the main rotor system, which necessitated a forced landing that resulted in substantial damage to the helicopter.NTSB CEN20LA261Accident · Minor injuriesClass 3 · LimitedFinal reportEnstrom 280 · Des Moines, IAThe partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…NTSB ANC20CA063Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Nikolai, AKThe pilot's improper decision to depart from an unsuitable off-airport surface which resulted in a departure area excursion and impact with trees.NTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…NTSB WPR20LA176Accident · 1 fatalClass 3 · LimitedFinal reportVans RV4 · Safford, AZA loss of pitch control during the landing approach due to a jammed elevator control system.NTSB CEN20CA213Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Cadillac, MIThe pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.NTSB WPR20CA146Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Perris, CAThe pilot's diverted attention while taxing which resulted in his failure to maintain clearance from the skip loader during taxi.NTSB WPR20LA131Accident · 3 fatalClass 3 · LimitedFinal reportBeech 35 · Currie, NVThe pilot’s failure to maintain airplane control during a forced landing which resulted in a hard landing for reasons that could not be determined based on available evidence.NTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.NTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.NTSB DCA20WA078Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB ANC20LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Hooper Bay, AKThe pilot’s decision to depart from a contaminated runway, and his failure to make a timely decision to abort the takeoff when the airplane was not accelerating as expected. Contributing to the accident was the pilot’s decision to depart in limited visibility…NTSB DCA20WA068Incident · No injuriesForeign investigationBoeing 737 · Madrid, SpainThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737-300, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist…NTSB DCA20WA063Incident · No injuriesForeign investigationAirbus A300 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an incident involving a AIRBUS A300 airplane that occurred on January 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB WPR20WA129Accident · Minor injuriesClass 5 · ForeignCessna U206G · Happy Valley, Australia