NTSB investigations, 1994, 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
Latest 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\") = 1994
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") = 1994 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 SEA95LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Murphy, IDThe pilot's failure to maintain altitude/clearance from the terrain. Factors include a dark night and a strong headwind.NTSB SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.NTSB SEA95LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · Lewiston, IDFuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.NTSB SEA95LA014Accident · No injuriesLimited investigationFinal reportCessna 205A · Lowell, IDThe pilot in command's long and fast landing. A factor was the wet runway surface condition.NTSB SEA95LA005Accident · Minor injuriesLimited investigationFinal reportLarsen Avid Heavy Hauler · Nampa, IDLoss of engine power for undetermined reasons and the lack of suitable terrain for the forced landing.NTSB SEA94LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Nampa, IDDirectional control was not maintained. A factor to the accident was: inadequate supervision.NTSB SEA94LA235Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Coolin, IDThe failure of the engine manufacturer to properly remanufacture and adequately inspect the no. 1 rocker arm prior to its installation on the engine. This resulted in fatigue cracking of the rocker arm and a subsequent loss of engine power.NTSB SEA94LA232Accident · No injuriesLimited investigationFinal reportCessna 210D · Paris, IDAn inadvertent wheels up landing.NTSB SEA94LA222Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Caldwell, IDThe jamming of the right main landing gear brake due to an accumulation of a gummy deposit.NTSB SEA94LA224Accident · No injuriesLimited investigationFinal reportCessna 206 · Bliss, IDThe pilot's failure to maintain directional control. Factors include sunglare from the setting sun, and the soft terrain along the side the runway.NTSB SEA94T#A04Accident · No injuriesClass 3Final reportde Havilland DHC-6-300 · Mccall, IDNTSB SEA94LA215Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hailey, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was a tailwind.NTSB SEA94LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDFuel starvation due to the pilot-in-command's failure to verify the fuel tank selector position during the approach, and his failure to perform the published emergency procedures for an engine-out situation. A factor in the accident was a transmission wire.NTSB SEA94LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Salmon, IDThe pilot's failure to adequately judge the distance and altitude to the runway during the night VFR approach. Factors in the accident were: fatigue, lack of recent night flying experience, the dark night, and the operator's inadequate supervision of the…NTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.NTSB SEA94LA196Accident · No injuriesLimited investigationFinal reportCessna T210M · Rathdrum, IDThe fatigue failure of the crankshaft and a slipped bearing.NTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.NTSB SEA94LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Wilder, IDThe failure of the left brake master cylinder and the pilot's inadequate remedial action when the aircraft collided with an embankment during an intentional ground loop.NTSB SEA94LA186Accident · No injuriesLimited investigationFinal reportEiriavion PIK20D-78 · Rexberg, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a vehicle parked near the runway.NTSB SEA94LA169Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Weiser, IDClearance from powerlines was not maintained. Factors include dusk light conditions.NTSB SEA94FA168Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Arco, IDThe pilot's diversion of his attention of controlling the airplane which led to his failure to maintain adequate airspeed. A factor which contributed to the accident was the pilot's failure to assure that the cabin door was closed and locked.NTSB SEA94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Lowell, IDThe pilot in command's failure to maintain adequate airspeed.NTSB SEA94LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccall, IDThe pilot's inadequate preflight planning and attempted operation which exceeded the performance capability of the airplane. Factors include his overconfidence in the aircraft's ability.NTSB SEA94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Indian Valley, IDConnecting rod bolt fatigue and no suitable terrain for the forced landing.NTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.NTSB SEA94LA136Accident · No injuriesLimited investigationFinal reportAyres S2R · Burley, IDA loose carburetor. Factors include no suitable terrain for making a forced landing, and trees in the field where the forced landing took place.NTSB SEA94LA133Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Lookout Pass, IDPoor in-flight planning. Factors include cloudy weather.NTSB SEA94LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDEngine failure after loss of oil due to a ruptured oil line.NTSB SEA94LA127Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Princeton, IDInadvertent retarding of throttle by pilot. Factors include trees.NTSB SEA94FA123Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Challis, IDThe pilot's failure to maintain clearance from terrain.NTSB SEA94FA106Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Kellogg, IDFailure of the pilot to maintain aircraft control, due to spatial disorientation, while flying with partial panel, and the design stress limits of the aircraft being exceeded. Factors related to the accident were: failure of the vacuum system, which resulted…NTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.NTSB SEA94LA093Accident · No injuriesLimited investigationFinal reportCessna 210D · Cobalt, IDThe pilot selected unsuitable terrain for landing. Factors in the accident were: the wet runway and rising terrain that precluded a go-around.NTSB SEA94LA090Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Driggs, IDDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB SEA94LA081Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Dubois, IDThe pilot's inadequate visual lookout. Factors include light conditions at dusk.NTSB SEA94LA075Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanley, IDThe pilot's failure to maintain the proper descent rate. Factors include downdrafts on final approach.NTSB SEA94LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Nampa, IDThe pilot in command's failure to refuel the aircraft. Factor(s) contributing to the accident were: fuel exhaustion, lack of total experience in type aircraft, and terrain condition (ditch).NTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.