NTSB investigations, 1997, 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\") = 1997
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") = 1997 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 CHI98LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boone, IAfailure of the pilot to maintain sufficient altitude/clearance from obstruction(s), while flying low over a river. The obstruction (power line) was a related factor.NTSB CHI98LA050Accident · No injuriesLimited investigationFinal reportCessna 402B · Spencer, IAThe pilot failure to comply with the prescribed IFR procedure and his not following his company's operations specifications. Low clouds and fog were are contributing factors.NTSB CHI98LA015Accident · No injuriesLimited investigationFinal reportReed-Madsen Taylor Bird · Humboldt, IAthe failure of the pilot-in-command to attain airspeed and maintain control of the aircraft, resulting in a stall/mush.NTSB CHI97LA288Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Amana, IAthe pilot's improper planning/decision. The fence (location) was a related factor.NTSB CHI97LA291Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, IAthe instructor pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane. Factors were the improper flare by the dual student and the instructor pilot's lack of familiarity with the airplane.NTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.NTSB CHI97LA275Accident · Minor injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · Blakesburg, IALoss of engine power for undetermined reasons.NTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.NTSB CHI97LA266Accident · Minor injuriesLimited investigationFinal reportSwearingen SA226TC · Des Moines, IAthe pilot's improper in-flight planning/decision and failure to perform the emergency procedure for shut-down of the right engine. Factors relating to the accident were: the power lever cable became disconnected from the fuel control unit, due to improper…NTSB CHI97LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Keokuk, IAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise, failure (collapse) of the nose gear, and a subsequent nose over.NTSB CHI97LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mapleton, IAthe loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.NTSB CHI97LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Ottumwa, IAthe improper flare performed by the student and the inadequate recovery from the bounced landing. A factor related to the accident was the student lack of experience.NTSB CHI97GA166Accident · Serious injuriesFinal reportHughes 269A-1 · Cedar Rapids, IAloss of engine power due to undetermined reason(s). Related factors included the obstructions (building, utility pole, and transmission wires); and the lack of a functional windsock, due to inadequate facility maintenance by the operator.NTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.NTSB CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.NTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.NTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.NTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.NTSB CHI97LA094Accident · No injuriesLimited investigationFinal reportCessna 195 · Cedar Rapids, IAoverload failure of the left main landing gear for undetermined reason(s). A factor associated with the accident was the gusty crosswind condition.NTSB CHI97IA072Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Des Moines, IAthe cross tie relay shorted resulting in a fire in the left main electrical equipment rack.NTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.NTSB CHI97LA053Accident · No injuriesLimited investigationFinal reportLearjet 24 · Muscatine, IAthe pilot's failure to maintain directional control. A factor was the snow covered runway edge.