NTSB investigations, 1989, 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\") = 1989
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") = 1989 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 SEA90LA008Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Salmon, IDFailure of pilot to properly evaluate weather conditions through mountainous terrain and fly at an altitude high enough to maintain terrain clearance.NTSB SEA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Homedale, IDInaccurate preflight planning and fuel consumption calculations by the pilot, and the pilot becoming lost or disoriented which resulted in fuel exhaustion.NTSB SEA89LA179Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Mackay, IDThe pilot failed to maintain an adequate airspeed for flight. High density altitude was a factor.NTSB SEA89LA162Accident · No injuriesLimited investigationFinal reportCessna TU206G · Moore, IDFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Contributing to the accident was a fence.NTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.NTSB DEN89FA202Accident · 4 fatalField investigationFinal reportAerospatiale AS-350D · Blanchard, IDOverheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.NTSB SEA89LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Atlanta, IDThe pilot's failue to adequately compensate for the downdraft conditions. Contributing factor(s) was: the downwind, downdraft, and high density altitude weather conditions, and the surrounding mountainous terrain.NTSB SEA89FA139Accident · 2 fatalField investigationFinal reportStinson 108-2 · Athol, IDThe pilot failed to maintain airspeed and inadvertently stalled.NTSB SEA89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Meridian, IDThe pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB SEA89LA132Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Middleton, IDThe pilot did not maintain an adequate visual lookout. A factor was the guy wires at the edge of the field.NTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA89FA113Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Stanley, IDPilot continued VFR flight into IMC conditions in mountainous terrain. Factors were snow squalls and obscured mountainous terrain in the area.NTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.NTSB SEA89LA095Accident · No injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDA loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB SEA89LA087Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDThe pilot's improper use of the helicopter's flight controls. Contributing to the accident was the pilot's misjudgement of the external load characteristics.NTSB SEA89LA083Accident · Serious injuriesLimited investigationFinal reportDavis Starship Alpha · Star, IDFailure of the propeller drive belt (stripped teeth). Contributing factors were: strong/gusty winds and the hilly terrain.NTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB SEA89LA058Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Jerome, IDThe failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel.NTSB SEA89LA048Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cottonwood, IDThe pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.