NTSB investigations, 1995, ID
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1995
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") = 1995 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 SEA96IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Boise, IDthe pilot-in-command's misjudgment of the remedial action necessary to correct the aircraft's misalignment with the runway. The dark night conditions, fog, and the pilot-in-command's failure to maintain proper alignment with the runway were factors.NTSB SEA96FA021Accident · 3 fatalField investigationFinal reportCessna 210D · Yellow Pine, IDimproper planning/decision by the pilot, his resultant VFR flight into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance from mountainous terrain. Factors relating to the accident were: the adverse weather…NTSB SEA96LA014Accident · No injuriesLimited investigationFinal reportCessna 180J · Stanley, IDthe pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.NTSB SEA96LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Ola, IDThe pilot's inadequate preflight preparation by failing to determine that the takeoff area was clear of obstructions. The rock was a factor.NTSB SEA95LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Roberts, IDan improperly performed major rebuild and inadequate inspection of the aircraft by maintenance personnel. Inadequate preflight inspection by the pilot contributed to the accident.NTSB SEA95LA225Accident · No injuriesLimited investigationFinal reportCessna TR182 · Richfield, IDThe instructor's failure to use carburetor heat during a simulated engine-out descent. Carburetor icing conditions was a factor.NTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…NTSB SEA95LA220Accident · No injuriesLimited investigationFinal reportHiller UH-12A · Bonners Ferry, IDThe flight instructor's misjudging his flare during a simulated autorotation.NTSB SEA95FA212Accident · 2 fatalField investigationFinal reportAero Commander 560 · Ketchum, IDThe pilot-in-command's failure to maintain adequate airspeed during a turn resulting in a stall/spin. Factors contributing to the accident were the pilot-in-command's becoming geographically disoriented as well as his improper in-flight decision, and…NTSB SEA95LA192Accident · Serious injuriesLimited investigationFinal reportNorth American T-28A · Rexburg, IDfatigue failure of the main hydraulic line and a resulting hydraulic fluid fire. Lack of suitable terrain for the forced landing contributed to the accident.NTSB SEA95LA174Accident · No injuriesLimited investigationFinal reportCessna T210K · Bliss, IDThe pilot's failure to properly manage the fuel system to avoid running a tank dry at a low altitude. A factor was the lack of suitable terrain for a forced landing.NTSB SEA95LA177Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Boise, IDimproper adjustment of the engine fuel control units by company maintenance personnel which led to excessive fuel flow and subsequent partial loss of engine power. Factors contributing to the accident were the rough terrain and high density altitude.NTSB SEA95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe left main landing gear tire burst during takeoff.NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.NTSB SEA95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idaho Falls, IDThe pilot's inadequate airspeed at liftoff. Contributing to the accident were high density altitude, tailwind conditions, the pilot's selection of an excessive takeoff flap setting, and a windshear encounter.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB SEA95LA149Accident · No injuriesLimited investigationFinal reportEdwin J. Estenson RV-4 · Elk River, IDThe pilot failed to maintain directional control. The tall vegetation was a factor.NTSB SEA95LA146Accident · No injuriesLimited investigationFinal reportMooney M20G · Rigby, IDThe pilot's premature liftoff and failure to attain adequate airspeed during takeoff. The high density altitude was a factor.NTSB SEA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mccall, IDImproper planning/decision by the pilot, which resulted in his failure (or inability) to remain clear of terrain after initiating a go-around. Factors relating to the accident were: the unfavorable terrain and wind conditions (including downdrafts).NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB SEA95LA142Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Island Park, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was wind gusts.NTSB SEA95LA135Accident · No injuriesLimited investigationFinal reportCessna 172L · Stanley, IDThe pilot's failure to use all available runway, his improper use of flaps, and his failure to maintain airspeed. A factor contributing to the accident is high density altitude.NTSB SEA95LA131Accident · No injuriesLimited investigationFinal reportCessna 172F · Homedale, IDThe pilot misjudged distance and altitude during the approach. The downdraft was a factor.NTSB SEA95LA130Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Challis, IDThe pilot's failure to maintain an adequate supply of fuel for the flight. The terrain condition was a factor.NTSB SEA95LA117Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Challis, IDInadequate preflight/planning preparation. Factors to the accident were: downdraft and tailwind.NTSB SEA95LA112Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Caldwell, IDThe pilot's failure to maintain clearance from power lines. Factors include sunglare encountered when he turned into the sun.NTSB SEA95LA108Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Terreton, IDThe pilot's failure to maintain an adequate altitude to overcome the downdraft. The downdraft was a factor.NTSB SEA95LA106Accident · No injuriesLimited investigationFinal reportCessna 206 · Grangeville, IDThe failure of the pilot to adequately recover from a bounced landing, and his failure to maintain directional control of the airplane during the landing roll. A factor contributing to the accident was a ditch.NTSB SEA95LA104Accident · No injuriesLimited investigationFinal reportBeech 77 · New Meadows, IDA partial loss of engine power after takeoff for undetermined reasons.NTSB SEA95LA092Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bliss, IDThe pilot's continued VFR flight into instrument meteorological conditions. Factors include low ceiling, rain and fog.NTSB SEA95LA076Accident · No injuriesLimited investigationFinal reportCessna 402B · Boise, IDFailure of both pilots to perform adequate visual lookout during taxi, and the ground controller's failure to identify the position of the Piper PA-34 before issuing taxi instructions. Factors relating to the accident were: decreased visibility due to…NTSB SEA95LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Boise, IDFuel exhaustion due to the pilot's failure to refuel.NTSB SEA95LA063Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Bonners Ferry, IDRotor RPM was not maintained. Factors to the accident were: inadequate in flight planning/decision and suitable terrain was not available.NTSB SEA95FA052Accident · 2 fatalField investigationFinal reportCessna 150M · Burley, IDThe failure of the dual student to maintain airspeed while maneuvering, and the flight instructor's inadequate supervision.NTSB SEA95LA045Accident · No injuriesLimited investigationFinal reportCessna 185 · Mccall, IDThe pilot's premature lift-off during the takeoff, leading to an aerodynamic stall. A factor contributing to the accident was the pilot's attempt to perform a formation takeoff.