NTSB investigations, 1981, 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\") = 1981
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") = 1981 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 CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INNTSB CHI82FEX06Accident · No injuriesClosedCessna 182G · Jeffsonville, INNTSB CHI82DEX03Accident · No injuriesClosedPiper PA-28 · Lafayette, INNTSB CHI82DEX02Accident · No injuriesClosedPiper PA-22 · Anderson, INNTSB CHI82FEX01Accident · Serious injuriesClosedPiper PA-31T · Madison, INNTSB CHI82DET02Accident · No injuriesClosedGulfstream AA-5A · Peru, INNTSB CHI82FA012Accident · 1 fatalClosedCessna 150 · Palmyra, INNTSB CHI82FA008Accident · 2 fatalClosedPiper PA-28 · Mooresville, INNTSB CHI82FA007Accident · 4 fatalClosedCessna 172 · Kokomo, INNTSB CHI82FET01Accident · No injuriesClosedCessna 150 · Ft Wayne, INNTSB CHI81FEX30Accident · No injuriesClosedPiper PA-28 · Noblesville, INNTSB CHI81FEX29Accident · No injuriesClosedAerospatial AS350D · Lynnville, INNTSB CHI81FEX22Accident · Minor injuriesClosedCessna 152 · Cayuga, INNTSB CHI81DEV35Accident · Minor injuriesClosedGrumman G-164A · Dana, INNTSB CHI81FET14Accident · 1 fatalClosedPDQ 2D · Goshen, INNTSB CHI81FET15Accident · No injuriesClosedBeech V35B · Ft Wayne, INNTSB CHI81FET13Accident · Minor injuriesClosedCessna 172E · Laporte, INNTSB CHI81FA098Accident · No injuriesClosedCessna 172N · Muncie, INNTSB CHI81DEX27Accident · No injuriesClosedCessna 182RG · West Middleton, INNTSB CHI81DEX26Accident · No injuriesClosedCessna 152 · Shelbyville, INNTSB CHI81FEX25Accident · Serious injuriesClosedN American AT-6G · Indianapolis, INNTSB CHI81FET10Accident · No injuriesClosedMooney M20F · South Bend, INNTSB CHI81FEX23Accident · No injuriesClosedGrum-Amer AA-5A · Waveland, INNTSB CHI81FET09Accident · No injuriesClosedCessna R182 · Plymouth, INNTSB CHI81FA068Accident · 4 fatalClosedGrum Amer AA-5A · Mccordsville, INNTSB CHI81FEX20Accident · No injuriesClosedGrumman G-164A · Remington, INNTSB CHI81FEX21Accident · No injuriesClosedTaylorcraft BC-65 · Paoli, INNTSB CHI81DEX24Accident · No injuriesClosedCessna 152 · Sedalia, INNTSB CHI81FEX19Accident · Serious injuriesClosedCessna 172N · Jasonville, INNTSB CHI81FEX18Accident · Minor injuriesClosedCessna 210J · Wirt, INNTSB CHI81FEX17Accident · No injuriesClosedCessna 402 · Jeffersonville, INNTSB CHI81FET08Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INNTSB CHI81FEX16Accident · Serious injuriesClosedSchweizer 2-33A · Zionsville, INNTSB CHI81FA064Accident · 2 fatalClosedBrantley B2B · Chesterton, INNTSB CHI81FEX15Accident · Serious injuriesClosedSmith Mini DSA-1 · Kokomo, INNTSB CHI81FET07Accident · Minor injuriesClosedPDQ 2-D · Ligonier, INNTSB CHI81FA061Accident · 1 fatalClosedBeech T-34B · New Castle, INNTSB CHI81FA057Accident · 1 fatalClosedAero Comdr 560 · Walkerton, INNTSB CHI81FEX14Accident · No injuriesClosedPitts S-1C · Indianapolis, INNTSB CHI81FA046Accident · 2 fatalClosedBellanca 7KCAB · Lafayette, INNTSB CHI81FET06Accident · No injuriesClosedLake LA-4 · Laporte, INNTSB CHI81FEX13Accident · No injuriesClosedCessna 172 · Marion, INNTSB CHI81FEX12Accident · No injuriesClosedPiper PA-28 · Portland, INNTSB CHI81DEX07Accident · No injuriesClosedCessna 172G · Clarksville, INNTSB CHI81FEX11Accident · No injuriesClosedErco 415-E · Carlisle, INNTSB CHI81FEX10Accident · Serious injuriesClosedCessna 182 · Indianapolis, INNTSB CHI81FA028Accident · 1 fatalClosedPiper PA-28R · Fort Wayne, INNTSB CHI81FA027Accident · 1 fatalClosedPiper PA-32 · Loganspopt, INNTSB CHI81IA025CaseClosedSwearingen SA226 · Indianapolis, INNTSB CHI81FET04Accident · No injuriesClosedMitsubishi MU-2B · Wabash, IN