NTSB investigations, 2024, ID
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2024
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") = 2024 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 WPR25LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Priest River, IDThe pilot's failure to attain a proper touchdown point and his inability to stop the landing roll on a wet gras runway, which resulted in a collision with a tree.NTSB WPR25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Aberdeen, IDThe pilot’s failure to maintain back pressure on the control stick during a landing attempt on gravel, which resulted in a nose over.NTSB WPR25LA021Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Rexburg, IDThe pilot’s failure to see and avoid transmission wires during the landing approach.NTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.NTSB WPR25LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Soda Springs, IDThe passenger’s inadvertent application of brakes during landing which resulted in a nose over.NTSB WPR24LA322Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Paris, IDThe pilot’s failure to properly configure the flaps, which resulted in a loss of directional control during takeoff.NTSB WPR24LA315Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Kooskia, IDThe pilot’s decision to descend into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees and terrain.NTSB WPR24LA311Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC11 · Grand View, IDThe pilot’s loss of control after encountering a dust devil during taxi.NTSB WPR24LA312Accident · No injuriesClass 4 · LimitedFinal reportConner Michael A Vans Acft RV-9 · Yellow Pine, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an impact with a fence.NTSB WPR24FA288Accident · 2 fatalClass 3 · FieldPreliminary reportTextron T206H · Yellow Pine, IDOn August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR24LA292Accident · No injuriesClass 4 · LimitedFinal reportRonald J Mclaughlin Bearhawk Patrol · Shearer, IDThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR24LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Stanley, IDThe pilot’s loss of directional control in reduced visibility conditions due to a wind gust, which resulted in a collision with a trailer.NTSB WPR24LA280Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Island Park, IDA loss of lateral control during takeoff due to an accumulation of water in the right wing.NTSB WPR24LA279Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Boise, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.NTSB WPR24LA240Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Soldier, IDA total loss of engine power resulting from the failure of the No. 1 piston and the No. 2 piston connecting rod due to detonation.NTSB WPR24LA247Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Stanley, IDA sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.NTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…NTSB WPR24LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Chamberlain Guard Station, IDThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a rodent hole and subsequent nose over.NTSB WPR24LA208Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Yellow Pine, IDThe pilot’s failure to attain a proper touchdown point during landing and his subsequent excessive use of brakes.NTSB WPR24FA201Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Arco, IDA midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…NTSB WPR24LA203Accident · No injuriesClass 4 · LimitedFinal reportJoseph H Mason Bearhawk Patrol · Twin Falls, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR24LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Nampa, IDLoss of directional control during the takeoff roll.NTSB WPR24FA190Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Elk River, IDThe pilot’s failure to maintain clearance from terrain while climbing in mountainous terrain during moderately high density altitude conditions, and conditions conducive to severe carburetor icing.NTSB WPR24LA170Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · McCall, IDThe pilot’s failure to maintain directional control during the landing roll with a gusty right crosswind.NTSB WPR24LA149Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Bonners Ferry, IDThe student pilot’s failure to maintain control of the airplane during landing in gusting wind conditions.NTSB WPR24LA147Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Emmett, IDThe pilot’s loss of directional control during landing roll due to a loose tailwheel leaf spring assembly.NTSB WPR24LA138Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA315B · Lewiston, IDThe pilot’s failure to maintain clearance from power lines during a low level aerial application.NTSB WPR24LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Challis, IDThe pilot’s failure to attain a proper touchdown point during landing which resulted in a runway excursion and subsequent nose over.NTSB WPR24LA122Accident · No injuriesClass 3 · LimitedFinal reportCessna 180A · Nordman, IDMaintenance personnel's improper installation of the left main landing gear wheel assembly, which resulted in a loss of torque and subsequent separation of the wheel and axle assembly from the main landing gear leg during landing.NTSB WPR24LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Weippe, IDThe pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…NTSB WPR24LA079Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Featherville, IDThe pilot's failure to maintain directional control during taxi, which resulted in a runway excursion and impact with terrain.