NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09CA044Accident · No injuriesData collectionFinal reportCessna 172M · Carroll, IAThe improper preflight planning/decision made by the pilot in attempting a taxi in high wind conditions. Contributing to the accident was the winds.NTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.NTSB CHI08CA290Accident · No injuriesData collectionFinal reportUnknown Supercat · Redding, IAThe pilot's failure to properly manage the fuel supply of the airplane which resulted in fuel exhaustion. Contributing to the accident was the hilly terrain encountered during the subsequent forced landing.NTSB CHI08CA261Accident · Minor injuriesData collectionFinal reportNtbk Wag Aero Sport · Oxford, IAThe pilot misjudged his approach path which resulted in insufficient altitude and the subsequent failure to maintain clearance with the trees. Contributing to the accident were the trees and the dusk lighting conditions.NTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.NTSB CHI08CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301B · Monticello, IAPoor preflight planning in that the pilot failed to assure an adequate fuel supply was on board for the flight which resulted in fuel exhaustion. Factors associated with the accident were the low altitude of the airplane when the loss of power occurred and…NTSB CHI08CA213Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Ida Grove, IAA failure of the turbocharger blower which resulted in the partial loss of power. Factors associated with the accident were the low altitude of the airplane and the embankment.NTSB CHI08CA242Accident · No injuriesData collectionFinal reportSchweizer G-164A · Jefferson, IAThe loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.NTSB CHI08CA240Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Salem, IAThe loss of engine power for an undetermined reason. Contributing to the accident was the high grass encountered during the landing roll.NTSB CHI08CA218Accident · No injuriesData collectionFinal reportCessna T188C · Marion, IAThe pilot not maintaining airspeed while performing an aerial application maneuver and the inadvertent stall he encountered. Contributing to the accident was the gust of wind during the maneuver.NTSB CHI08CA220Accident · Minor injuriesData collectionFinal reportAir Tractor AT-401 · Lake View, IAThe pilot not obtaining/maintaining altitude/clearance from the power line while performing an aerial application maneuver.NTSB CHI08CA205Accident · Minor injuriesData collectionFinal reportHowell FW2C80TR · Washington, IAThe low airspeed and proper climb rate not attained by the pilot during takeoff and the inadvertent stall by the pilot.NTSB CHI08CA204Accident · Serious injuriesData collectionFinal reportIndy T-Bird II · Independence, IAThe takeoff airspeed not attained and the aborted takeoff not performed by the pilot. An additional cause was the lack of familiarity with the airplane by the pilot.NTSB CHI08LA189Accident · Serious injuriesLimited investigationFinal reportRoof Curtis Hawk P6E · Iowa City, IAThe loss of engine power for an undetermined reason and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB CHI08FA150Accident · 1 fatalField investigationFinal reportSocata TBM 700 (850) · Iowa City, IAThe pilot's improper decision to depart with a preexisting tailwind and failure to abort takeoff. Contributing to the severity of the injuries was the failure to properly restrain (FAA-required) the child passenger.NTSB CHI08LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Fairfax, IAFuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.NTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.