NTSB investigations, 1994, IA
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
| 1962 | 2 |
|---|---|
| 1963 | 2 |
| 1964 | 72 |
| 1965 | 74 |
| 1966 | 108 |
| 1967 | 129 |
| 1968 | 87 |
| 1969 | 98 |
| 1970 | 101 |
| 1971 | 105 |
| 1972 | 76 |
| 1973 | 53 |
| 1974 | 60 |
| 1975 | 49 |
| 1976 | 55 |
| 1977 | 57 |
| 1978 | 65 |
| 1979 | 51 |
| 1980 | 41 |
| 1981 | 60 |
| 1982 | 52 |
| 1983 | 53 |
| 1984 | 39 |
| 1985 | 35 |
| 1986 | 26 |
| 1987 | 30 |
| 1988 | 27 |
| 1989 | 24 |
| 1990 | 24 |
| 1991 | 23 |
| 1992 | 23 |
| 1993 | 22 |
| 1994 | 16 |
| 1995 | 12 |
| 1996 | 15 |
| 1997 | 22 |
| 1998 | 20 |
| 1999 | 18 |
| 2000 | 11 |
| 2001 | 7 |
| 2002 | 14 |
| 2003 | 20 |
| 2004 | 13 |
| 2005 | 13 |
| 2006 | 8 |
| 2007 | 17 |
| 2008 | 18 |
| 2009 | 17 |
| 2010 | 27 |
| 2011 | 23 |
| 2012 | 21 |
| 2013 | 15 |
| 2014 | 9 |
| 2015 | 13 |
| 2016 | 13 |
| 2017 | 16 |
| 2018 | 12 |
| 2019 | 9 |
| 2020 | 12 |
| 2021 | 16 |
| 2022 | 14 |
| 2023 | 17 |
| 2024 | 7 |
| 2025 | 13 |
| 2026 | 15 |
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\" = 'IA' 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" = 'IA' 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 CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.NTSB CHI95LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · La Porte City, IAa material defect which resulted in the fatigue failure of the crankshaft and the aircraft owner's failure to comply with a Mandatory Service Bulletin addressing the defect. A factor related to the accident was the rough terrain on which the forced landing…NTSB CHI94LA343Accident · No injuriesLimited investigationFinal reportCessna 150 · North Hedrick, IAInadequate preflight planning and the selection of unsuitable terrain on which to initiate a takeoff. A factor in this accident was the pilot's lack of overall experience.NTSB CHI94LA322Accident · No injuriesLimited investigationFinal reportCessna 172N · Boone, IAthe failure of both pilots to adequately monitor radio communications during an exceptionally busy period. Factors related to the accident were the high vegetation and the failure of airport personnel to recognize and correct a hazardous situation.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB CHI94LA302Accident · Minor injuriesLimited investigationFinal reportFrith Challenger II · Fairfield, IAthe total failure and separation of the propeller system drive belt. Obstacles (powerlines and pole) were a factor in the accident.NTSB CHI94LA299Accident · Minor injuriesLimited investigationFinal reportRobert Eldon Idler TIERRA-2 · Prole, IAthe airplane's encounter with the outflow (gust front) from an approaching thunderstorm. Factors were the pilot's inaccurate evaluation of the gust front location, and the inability of the airplanes flight control system to compensate for the rolling moment.NTSB CHI94LA295Accident · No injuriesLimited investigationFinal reportSchreiber-Stitts SA-3B · Muscatine, IAA loose intake manifold pipe on the airplane's engine which resulted from improper maintenance. Factors associated with this accident were the builder/pilot improperly installing the intake manifold pipe and the alternate landing area's high vegetation.NTSB CHI94LA293Accident · No injuriesLimited investigationFinal reportSnow 600B · Grundy Center, IAthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were condition of the runway, the road, and the ditch.NTSB CHI94LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Marion, IAThe pilot's inadequate aircraft prelight and his failure to remove the frost from the windshield which obstructed his view.NTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.NTSB CHI94LA228Accident · No injuriesLimited investigationFinal reportBeech 58 · Oelwein, IAthe pilot's decision to land on a runway with a tailwind. Factors associated with the accident were the tailwind and the wet runway.NTSB CHI94LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Harlan, IAthe delayed remedial action by the flight instructor. A factor related to the accident was the wet runway surface.NTSB CHI94LA159Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Burlington, IAfuel exhaustion resulting from the failure of the pilot to refuel en route.NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.NTSB CHI94LA120Accident · No injuriesLimited investigationFinal reportDefelici Kitfox III · Oxford, IAthe failure of the pilot-in-command (CFI) to maintain directional control. A factor related to the accident was the inadvertent interference with the flight controls by the student pilot.