NTSB investigations, 1979, IN
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
| 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\") = 1979
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") = 1979 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 CHI80FEX03Accident · Minor injuriesClosedBeech B35 · Fairmount, INNTSB CHI80FET05Accident · Serious injuriesClosedErco 415-CD · Lake Village, INNTSB CHI80FA013Accident · 1 fatalClosedCessna 177 · Gary, INNTSB CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNTSB CHI80FET04Accident · No injuriesClosedPiper PA-32 · Laporte, INNTSB CHI80FET03Accident · No injuriesClosedCessna 172M · Mentone, INNTSB CHI80FEX02Accident · Serious injuriesClosedCessna 206 · Noblesville, INNTSB CHI80FEX01Accident · No injuriesClosedCessna 210E · Fairbanks, INNTSB CHI80FET02Accident · Minor injuriesClosedCessna 172N · Munster, INNTSB CHI80FA007Accident · 2 fatalClosedCessna 310 · Bloomington, INNTSB CHI80FA001Accident · 1 fatalClosedBellanca 17-31 · North Manchest, INNTSB CHI80DA003Accident · 1 fatalClosedCessna 152 · Syracuse, INNTSB CHI79FET34Accident · No injuriesClosedCessna 182P · South Bend, INNTSB CHI79AA082Accident · 5 fatalClosedPiper PA-32R · Indianapolis, INNTSB CHI79FET33Accident · No injuriesClosedPiper PA-22 · Peru, INNTSB CHI79FET32Accident · Minor injuriesClosedPiper PA-28 · Bluffton, INNTSB CHI79FET30Accident · No injuriesClosedCessna 152 · East Chicago, INNTSB CHI79DET29Accident · No injuriesClosedGrumman AA1C · Roselawn, INNTSB CHI79FEX41Accident · No injuriesClosedGrumman G-164A · Versailles, INNTSB CHI79DEX40Accident · No injuriesClosedCessna 172 · Delphi, INNTSB CHI79DEX39Accident · No injuriesClosedCessna 177 · Indianapolis, INNTSB CHI79FA079Accident · 2 fatalClosedCessna 310 · Blue Ridge, INNTSB CHI79DA068Accident · 1 fatalClosedCessna 177B · Bloomington, INNTSB CHI79FEX38Accident · No injuriesClosedPiper PA-28 · Evansville, INNTSB CHI79DEX37Accident · No injuriesClosedRaven RX-7 · Shelbyville, INNTSB CHI79FEX36Accident · No injuriesClosedCessna 150M · Richmond, INNTSB CHI79FET28Accident · No injuriesClosedPiper PA-28 · Crown Point, INNTSB CHI79FEX35Accident · No injuriesClosedPiper PA-28 · Indianapolis, INNTSB CHI79FEX34Accident · No injuriesClosedPiper PA-25 · Danville, INNTSB CHI79FA065Accident · 1 fatalClosedBeech C-90 · Indianapolis, INNTSB CHI79DET27Accident · No injuriesClosedBreezy DDJ-1 · Roselawn, INNTSB CHI79FET26Accident · Serious injuriesClosedN American SNJ-5 · Elkhart, INNTSB CHI79FET25Accident · Minor injuriesClosedCessna 180 · Craigville, INNTSB CHI79FEX33Accident · 1 fatalClosedTexas Heli OH-13 · Solitude, INNTSB CHI79DEX42Accident · No injuriesClosedLuscombe 8A · Brownsburg, INNTSB CHI79FET24Accident · Serious injuriesClosedPiper PA-23 · Hobart, INNTSB CHI79FEX32Accident · Minor injuriesClosedCessna 172 · Terra Haute, INNTSB CHI79DEX30Accident · Minor injuriesClosedCessna 172 · Anderson, INNTSB CHI79FEX28Accident · Minor injuriesClosedBoeing A75N1 · Indianapolis, INNTSB CHI79FET23Accident · No injuriesClosedGrumman AA5 · Elkhart, INNTSB CHI79FEX27Accident · Minor injuriesClosedBellanca 7ECA · Indianapolis, INNTSB CHI79FEX26Accident · No injuriesClosedBell 206-11 · Indianapolis, INNTSB CHI79FEX31Accident · Minor injuriesClosedCessna 172 · Martinsville, INNTSB CHI79FEX25Accident · No injuriesClosedBell 47J2 · Westfield, INNTSB CHI79DEX29Accident · No injuriesClosedPiper PA-28 · Hagertown, INNTSB CHI79FEX23Accident · Minor injuriesClosedLuscombe 8E · Lanesville, INNTSB CHI79FEX22Accident · No injuriesClosedCessna 340 · Columbus, INNTSB CHI79FEX21Accident · Serious injuriesClosedBeech C-23 · Fishers, INNTSB CHI79FA045Accident · 2 fatalClosedPiper PA-28 · Veedersburg, INNTSB CHI79DEX20Accident · No injuriesClosedPiper PA-28 · Lafayette, IN