NTSB investigations, 1992, 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
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\") = 1992
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") = 1992 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 CHI93LA052Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Cedar Rapids, IAThe pilot-in-command's failure to maintain a proper glidepath.NTSB CHI93LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · La Porte City, IAThe pilot's failure to properly align the airplane with the runway.NTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.NTSB CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.NTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.NTSB CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.NTSB CHI93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Marion, IAThe loss of engine power for undetermined reasons.NTSB CHI93DCD01Accident · Serious injuriesFinal reportRichard O. Middlen Glasair III SH-3R · Larchwood, IAThe pilot-in-command's intentional low pass and his inadequate visual lookout.NTSB CHI92DCD10Accident · Minor injuriesFinal reportCurt Hoffstad Pitts S1-S · Council Bluffs, IAThe failure of the pilot to maintain aircraft control while maneuvering during aerobatic flight.NTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.NTSB CHI92DCD08Accident · Minor injuriesFinal reportJohn Schackel Q2 · Rutland, IAA fatigue failure of the engine crankshaft during cruise flight.NTSB CHI92DCD07Accident · Serious injuriesFinal reportBernard W. Resnik ACRO-SPECIAL · Earlham, IAA loss of total engine power when a failed flapper valve in the air box blocked the flow of air through the carburetor throat.NTSB CHI92LA193Accident · No injuriesLimited investigationFinal reportBell 47-2A-1 · Dubuque, IAThe pilot's failure to maintain both directional control of the helicopter and clearance from the truck.NTSB CHI92LA189Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Oxford, IAWas the pilot's failure to maintain directional control of the airplane during the landing. Factors related to the accident were the pilot's lack of experience in tail wheel airplanes and the gusty wind conditions.NTSB CHI92LA181Accident · No injuriesLimited investigationFinal reportNorth American NA-265-50 · Cedar Rapids, IAThe pilot-in-command's selection of the wrong runway for landing. A factor was the tailwind.NTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.NTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.NTSB CHI92DCD04Accident · No injuriesFinal reportHiller UH-12E · Milford, IAA total loss of engine power for an undetermined reason as the helicopter was performing aerial application maneuvers.NTSB CHI92DCD03Accident · Minor injuriesFinal reportPiper PA-36-375 · Deloit, IAInadequate visual lookout by the pilot in command while performing aerial application maneuvers. A factor in the accident is the pilot's diverted attention.NTSB CHI92LA124Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Garnavillo, IAThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in aircraft type.NTSB CHI92DCD02Accident · Minor injuriesFinal reportQuad City Challenger · Blakesburg, IAFailure of the pilot to maintain aircraft control during final approach. Weather conditions, high wind and turbulence, were factors in the accident.NTSB CHI92DCD01Accident · 1 fatalFinal reportRaymond Bristow Rand KR-2 · Boone, IAFailure of the pilot to maintain aircraft control. A factor in the accident is total failure of the airplane canopy.NTSB CHI92LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Cedar Rapids, IAA result of the pilot-in-command not understanding the airplanes emergency procedures and not performing the appropriate emergency procedures. A factor associated with the accident was an electrical system failure.