NTSB investigations, 1971, IN
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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
| 1963 | 1 |
|---|---|
| 1964 | 107 |
| 1965 | 116 |
| 1966 | 119 |
| 1967 | 132 |
| 1968 | 106 |
| 1969 | 88 |
| 1970 | 83 |
| 1971 | 81 |
| 1972 | 88 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 86 |
| 1976 | 78 |
| 1977 | 90 |
| 1978 | 95 |
| 1979 | 70 |
| 1980 | 76 |
| 1981 | 52 |
| 1982 | 55 |
| 1983 | 54 |
| 1984 | 55 |
| 1985 | 54 |
| 1986 | 58 |
| 1987 | 53 |
| 1988 | 66 |
| 1989 | 45 |
| 1990 | 42 |
| 1991 | 33 |
| 1992 | 29 |
| 1993 | 35 |
| 1994 | 38 |
| 1995 | 33 |
| 1996 | 31 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 22 |
| 2000 | 34 |
| 2001 | 29 |
| 2002 | 25 |
| 2003 | 20 |
| 2004 | 26 |
| 2005 | 20 |
| 2006 | 28 |
| 2007 | 23 |
| 2008 | 22 |
| 2009 | 30 |
| 2010 | 27 |
| 2011 | 26 |
| 2012 | 26 |
| 2013 | 22 |
| 2014 | 16 |
| 2015 | 19 |
| 2016 | 23 |
| 2017 | 22 |
| 2018 | 19 |
| 2019 | 22 |
| 2020 | 17 |
| 2021 | 21 |
| 2022 | 21 |
| 2023 | 16 |
| 2024 | 17 |
| 2025 | 13 |
| 2026 | 9 |
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\") = 1971
AND c.\"eventStateOrRegion\" = 'IN' 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") = 1971 AND c."eventStateOrRegion" = 'IN' 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 CHI72FEA25Accident · No injuriesClosedCessna 172 · Greencastle, INNTSB CHI72AC052Accident · 1 fatalClosedPiper PA-22 · Evansville, INNTSB CHI72DEA24Accident · No injuriesClosedCessna 172 · Martinsville, INNTSB CHI72FET11Accident · Serious injuriesClosedCessna 175 · Auburn, INNTSB CHI72FEA23Accident · Minor injuriesClosedCessna 150 · Pittsboro, INNTSB CHI72FEA19Accident · No injuriesClosedPiper PA-28 · Indianapolis, INNTSB CHI72FEA21Accident · No injuriesClosedCessna 310J · Monticello, INNTSB CHI72FEA17Accident · No injuriesClosedBensen B8M · Greenwood, INNTSB CHI72FET10Accident · No injuriesClosedHughes 269A · Griffith, INNTSB CHI72DEA22Accident · No injuriesClosedBeech J35 · Anderson, INNTSB CHI72FET09Accident · No injuriesClosedCessna 170 · Winamac, INNTSB CHI72DEA16Accident · No injuriesClosedPiper PA-32 · Anderson, INNTSB CHI72DEA14Accident · No injuriesClosedStinson 108-3 · Acton, INNTSB CHI72DEA15Accident · No injuriesClosedTaylorcraft BC12-D · Palmyra, INNTSB CHI72FEA20Accident · No injuriesClosedCessna 210G · Laconia, INNTSB CHI72FEA12Accident · No injuriesClosedWilson B8M · Columbus, INNTSB CHI72FET08Accident · Minor injuriesClosedLuscombe 8A · Elkhart, INNTSB CHI72DEA18Accident · No injuriesClosedCessna 172L · Martinsville, INNTSB CHI72AC019Accident · 2 fatalClosedPiper PA-22 · Angola, INNTSB CHI72FEA11Accident · Serious injuriesClosedBeech B35 · Monon, INNTSB CHI72DEA13Accident · No injuriesClosedPiper PA-28 · Delphi, INNTSB CHI72FET06Accident · Minor injuriesClosedBell 47G-2 · Laporte, INNTSB CHI72FEA10Accident · No injuriesClosedBellanca 14-13 · Whitestown, INNTSB CHI72FET05Accident · Minor injuriesClosedTaylorcraft BC-12D · Syracuse, INNTSB CHI72FEA09Accident · Minor injuriesClosedCessna 172K · Wolcott, INNTSB CHI72DET04Accident · No injuriesClosedCessna 120 · Warsaw, INNTSB CHI72FET03Accident · No injuriesClosedHughes 269B · Griffith, INNTSB CHI72FEA04Accident · No injuriesClosedBeech V35 · Winchester, INNTSB CHI72FET02Accident · Minor injuriesClosedBrantly 305 · Monroeville, INNTSB CHI72FEA07Accident · No injuriesClosedPiper PA-25 · Roachdale, INNTSB CHI72FEA03Accident · Minor injuriesClosedPiper J4A · Cloverdale, INNTSB CHI72FEA01Accident · No injuriesClosedBoeing A75N1 · Greensburg, INNTSB CHI72DEA08Accident · No injuriesClosedCessna 140 · Lebanon, INNTSB CHI72AC004Accident · 1 fatalClosedBeech C35 · Crown Point, INNTSB CHI72FET01Accident · No injuriesClosedAerostar 201 · Gary, INNTSB CHI72FEA02Accident · Minor injuriesClosedPiper PA-24 · Perrysville, INNTSB CHI71DEA40Accident · No injuriesClosedPiper PA-28 · Jeffersonvile, INNTSB CHI71FET31Accident · Serious injuriesClosedFleet 16B · Osceola, INNTSB CHI72DEA05Accident · No injuriesClosedBellanca 14-193 · Evansville, INNTSB CHI71IC092Incident · No injuriesClosedDouglas DC-9 · Indianapolis, INNTSB CHI71FEA39Accident · No injuriesClosedBensen B8-M · Delphi, INNTSB CHI71FET30Accident · No injuriesClosedCessna 177 · South Bend, INNTSB CHI71AC091Accident · 2 fatalClosedPiper PA-30 · Fort Wayne, INNTSB CHI71AC087Accident · 2 fatalClosedChampion 7ECA · Poseyville, INNTSB CHI71DET29Accident · No injuriesClosedPiper PA-24 · Michigan City, INNTSB CHI71AC086Accident · 2 fatalClosedCessna 182 · Lafayette, INNTSB CHI71FET28Accident · No injuriesClosedBeech 23 · Wolcottville, INNTSB CHI71DEA38Accident · No injuriesClosedPiper PA-20 · Seymour, INNTSB CHI71FEA37Accident · No injuriesClosedPiper PA-28 · Muncie, INNTSB CHI71FEA36Accident · No injuriesClosedCessna 182 · Muncie, IN