NTSB investigations, 2021, ID
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 per year
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
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\") = 2021
AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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") = 2021 AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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 WPR22LA036Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Mackay, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in the airplane veering into a ditch and nosing over.NTSB WPR22LA037Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to attain sufficient airspeed for the airplane to climb with a tailwind.NTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.NTSB WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.NTSB WPR22LA030Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.NTSB WPR22LA014Accident · No injuriesClass 3 · LimitedFinal reportAvid Mark IV · Payette, IDA total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.NTSB WPR21LA360Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182E · Warren, IDThe pilot’s failure to maintain altitude while maneuvering in a valley of mountainous terrain.NTSB WPR21LA361Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Elk River, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a fence.NTSB WPR21LA354Accident · No injuriesClass 3 · LimitedFinal reportHiller UH-12E · Bovill, IDA loss of helicopter control for undetermined reasons based on the available evidence for this accident.NTSB WPR21LA347Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Stanley, IDThe pilot’s failure to maintain airplane control during landing with a gusting crosswind which, resulted in a hard landing and collision with terrain.NTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB WPR21LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Athol, IDThe failure of the windshield during spin recovery for reasons that were not determined.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB WPR21LA302Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing with a crosswind which, resulted in a runway excursion and impact with terrain.NTSB WPR21FA283Accident · 1 fatalClass 3 · FieldFinal reportSiai-Marchetti SM-1019B · Lewiston, IDThe pilot’s failure to remove the flight control lock before departure, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was his failure to perform an adequate preflight inspection and flight control check…NTSB WPR21LA281Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Cascade, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB WPR21LA267Accident · No injuriesClass 4 · LimitedFinal reportJust JA30 Superstol · May, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop and collision with terrain.NTSB WPR21LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182C · Coeur D Alene, IDThe pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.NTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.NTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR21LA256Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Nampa, IDThe pilot’s failure to use the landing checklist and to extend the landing gear, which resulted in a gear-up landing.NTSB WPR21LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Ririe, IDThe pilot’s encounter with a tailwind during takeoff roll, which resulted in an aborted takeoff, collision with a ditch and subsequent nose over.NTSB WPR21LA234Accident · No injuriesClass 4 · LimitedFinal reportBolstridge Wallace R SKY Raider 1 · Nampa, IDA total loss of engine power due to the pilot’s failure to premix the two-cycle oil/gasoline mixture, which resulted in a forced landing in a field and collision with terrain.NTSB WPR21LA237Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · Warren, IDThe pilot's decision to continue the approach for landing with excess airspeed, which resulted in an aborted landing and subsequent collision with trees.NTSB WPR21LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Moose Creek Ranger Station, IDThe pilot’s improper landing flare which resulted in a bounced hard landing and subsequent nose over.NTSB WPR21LA229Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4 · Cascade, IDThe pilot’s failure to maintain clearance from a ditch, which resulted in impact with terrain.NTSB WPR21LA220Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24 · Paris, IDA total loss of engine power for reasons that could not be determined.NTSB WPR21LA212Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Stanley, IDThe pilot’s failure to use carburetor heat in weather conditions conducive to carburetor icing, resulting in a partial loss of engine power and a forced landing during which the airplane struck an object and nosed over.NTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.NTSB WPR21LA198Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Paris, IDThe pilot's improper flare which resulted in a bounced landing, loss of directional control and collision with terrain.NTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.NTSB WPR21LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Lewiston, IDThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in a taxiway excursion and collision with a fence.NTSB WPR21LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Driggs, IDThe pilot’s failure to maintain directional control while landing with gusting wind conditions, which resulted in a ground loop.NTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.NTSB WPR21LA153Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Sand Point, IDThe student pilot’s improper landing flare which resulted in a hard landing, loss of directional control and subsequent nose over.NTSB WPR21LA139Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Twin Falls, IDThe pilot’s failure to maintain airplane control during initial climb with a crosswind when the airspeed decreased, the airplane exceeded its critical angle of attack and aerodynamical stalled at too low an altitude for the pilot to recover before the…NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB WPR21LA128Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · McCall, IDThe pilot's loss of directional control while landing in a crosswind, which resulted in a ground loop.NTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.