NTSB investigations, 2015, 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\") = 2015
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") = 2015 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 CEN16FA062Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Council Bluffs, IAThe pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.NTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB CEN15LA412Accident · Minor injuriesLimited investigationFinal reportGuisinger Gary G Baby Belle · Stuart, IAThe failure of the tail rotor driveshaft for reasons that could not be determined due to the mechanically and thermally deformed fracture surface.NTSB CEN15LA370Accident · No injuriesLimited investigationFinal reportBell 206B · Cresco, IAThe loss of engine power due to the high-cycle fatigue failure of the third-stage turbine wheel.NTSB CEN15LA377Accident · No injuriesLimited investigationFinal reportGrumman G 164B · Sac City, IAThe loss of engine power for reasons that could not be determined based on the available information.NTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.NTSB CEN15LA322Accident · No injuriesLimited investigationFinal reportBell 47G 4A · Gilbert, IAThe total loss of engine power due to fuel starvation because the available fuel shifted within the tanks due to an abrupt nose-low maneuver to avoid an obstacle, which resulted in a hard forced landing.NTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA138Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Ute, IAThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent aerodynamic stall, and impact with terrain.NTSB GAA15CA137Accident · No injuriesData collectionFinal reportPiper PA 24 · Charles City, IAThe pilot's inadequate pre-flight fuel planning resulting in fuel exhaustion and a collision with terrain.NTSB GAA15CA125Accident · No injuriesData collectionFinal reportCessna 180B · Waterloo, IAThe incorrect installation of the secondary seat stop reel which resulted in the pilot's loss of control when the seat moved full aft during takeoff.NTSB CEN15CA203Accident · No injuriesData collectionFinal reportCessna 195A · Independence, IAThe pilot's attempt to land in strong crosswind conditions, resulting in his on-ground loss of control. Contributing to the accident was the crosswind that exceeded the crosswind limits of the airplane.NTSB GAA15LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garrison, IAThe malfunction of the right brake for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.