Skip to content

NTSB investigations, IL

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'IL' 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 c."eventStateOrRegion" = 'IL' 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 CHI66F0016Accident · No injuriesClosedErcoupe 415C · Blandinsville, ILJan 9, 1965 · N99540 · Substantial damage NTSB CHI65F0022Accident · No injuriesClosedBeechraft AT11 · Wheeling, ILJan 9, 1965 · N107RS · Substantial damage NTSB CHI65F0030Accident · No injuriesClosedBeechcraft 95 · Savoy, ILJan 7, 1965 · N2742Y · Substantial damage NTSB UNK65X1174Accident · No injuriesClosedAeronca 7FC · Oswego, ILDec 28, 1964 · N7573B · Substantial damage NTSB UNK65X1146Accident · Serious injuriesClosedLuscombe 11A · Hinsdale, ILDec 26, 1964 · N1633B · Destroyed NTSB UNK65X1131Accident · No injuriesClosedCessna 180 · Sherman, ILDec 25, 1964 · N9043C · Substantial damage NTSB UNK65X1118Accident · 1 fatalClosedPiper PA-24 · Bartonville, ILDec 24, 1964 · N6406P · Destroyed NTSB UNK65X1090Accident · No injuriesClosedHoward DGA-15 · West Chicago, ILDec 22, 1964 · N75599 · Substantial damage NTSB UNK65X1089Accident · No injuriesClosedBeechraft D95 · Groveland, ILDec 22, 1964 · N8613M · Substantial damage NTSB UNK65X1081Accident · No injuriesClosedPiper PA30 · Chicago, ILDec 21, 1964 · N7495Y · Substantial damage NTSB UNK65X1068Accident · No injuriesClosedPiper PA28 · Chicago, ILDec 20, 1964 · N7677W · Substantial damage NTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · Destroyed NTSB CHI66D0214Accident · No injuriesClosedPiper PA-24 · Peoria, ILDec 14, 1964 · N6237P · Substantial damage NTSB UNK65X0991Accident · 1 fatalClosedCessna 190 · Bradford, ILDec 12, 1964 · N4497C · Destroyed NTSB UNK65X0967Accident · No injuriesClosedPiper PA22 · Lockport, ILDec 10, 1964 · N5526Z · Substantial damage NTSB UNK65X0893Accident · 2 fatalClosedPiper PA-30 · Chicago, ILDec 1, 1964 · N7057Y · Destroyed NTSB UNK65X0855Accident · No injuriesClosedBeechcraft 35-A33 · Fairbury, ILNov 27, 1964 · N370Z · Substantial damage NTSB UNK65X0839Accident · No injuriesClosedCessna 195-A · Fairfield, ILNov 26, 1964 · N4479C · Substantial damage NTSB UNK65X0799Accident · No injuriesClosedPiper PA28 · Dixon, ILNov 22, 1964 · N6271W · Substantial damage NTSB UNK65X0797Accident · No injuriesClosedCessna 170B · Peoria, ILNov 22, 1964 · N4316B · Substantial damage NTSB UNK65X0706Accident · Minor injuriesClosedCessna 182 · Peoria, ILNov 14, 1964 · N3516Y · Substantial damage NTSB UNK65X0636Accident · Serious injuriesClosedConvair CV-880 · Chicago, ILNov 9, 1964 · N8805 · No damage NTSB UNK65X0613Accident · Serious injuriesClosedMooney M20A · Washington, ILNov 8, 1964 · N8303E · Substantial damage NTSB UNK65X0610Accident · No injuriesClosedAero Cmdr 520 · Chicago, ILNov 8, 1964 · N4172B · Substantial damage NTSB UNK65X0504Accident · No injuriesClosedSikorsky S58C · Joliet, ILOct 31, 1964 · N867 · No damage NTSB UNK65X0407Accident · No injuriesClosedBeechcraft 35-A33 · Marseilles, ILOct 24, 1964 · N9367Y · Substantial damage NTSB UNK65X0363Accident · No injuriesClosedBeechraft 95 · Savoy, ILOct 21, 1964 · N2742Y · Substantial damage NTSB UNK65X0350Accident · No injuriesClosedPiper PA22 · Hinsdale, ILOct 20, 1964 · N5941Z · Substantial damage NTSB UNK65X0337Accident · No injuriesClosedCessna 310 · Salem, ILOct 19, 1964 · N4825B · Substantial damage NTSB UNK65X0325Accident · No injuriesClosedPiper PA24 · Naperville, ILOct 18, 1964 · N7806P · Substantial damage NTSB UNK65X0312Accident · 3 fatalClosedMooney M20C · Antioch, ILOct 17, 1964 · N6215U · Destroyed NTSB UNK65X0286Accident · No injuriesClosedPiper PA24 · Sparta, ILOct 16, 1964 · N7144P · Substantial damage NTSB UNK65X0276Accident · No injuriesClosedMooney M18C · Pekin, ILOct 14, 1964 · N327M · Substantial damage NTSB UNK65X0191Accident · No injuriesClosedPiper PA-24 · Benton, ILOct 8, 1964 · N6723P · Substantial damage NTSB UNK65X0171Accident · No injuriesClosedPiper PA12 · Urbana, ILOct 7, 1964 · N78570 · Substantial damage NTSB UNK65X0157Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILOct 5, 1964 · N5828Z · 2 aircraft · Substantial damage NTSB UNK65X0135Accident · No injuriesClosedCessna 170 · Effingham, ILOct 4, 1964 · N4413V · Substantial damage NTSB UNK65X0122Accident · No injuriesClosedCessna 310R · Wheeling, ILOct 3, 1964 · N5252A · Substantial damage NTSB UNK65X0113Accident · No injuriesClosedMaule M4 · Chicago, ILOct 2, 1964 · N4716T · Substantial damage NTSB UNK64X4173Accident · No injuriesClosedLuscombe 8F · Waukegan, ILSep 27, 1964 · N1881B · Substantial damage NTSB UNK64X4148Accident · No injuriesClosedPiper PA24 · Elgin, ILSep 25, 1964 · N6831P · 2 aircraft · Destroyed NTSB UNK64X4144Accident · No injuriesClosedCessna 182 · Chicago, ILSep 25, 1964 · N5899B · Substantial damage NTSB UNK64X4115Accident · No injuriesClosedBeechcraft 95 · Wheeling, ILSep 23, 1964 · N9901R · Substantial damage NTSB UNK64X4092Accident · No injuriesClosedPiper PA22 · Taylorville, ILSep 22, 1964 · N3402A · Substantial damage NTSB UNK64X4081Accident · Serious injuriesClosedChampion 7FC · Columbia, ILSep 20, 1964 · N9043B · Destroyed NTSB UNK64X4072Accident · No injuriesClosedNavion A · Wheeling, ILSep 20, 1964 · N8585H · Substantial damage NTSB UNK64X4053Accident · No injuriesClosedBeechcraft C35 · Decatur, ILSep 19, 1964 · N642D · Substantial damage NTSB UNK64X3986Accident · Minor injuriesClosedCessna 172 · Wheeling, ILSep 14, 1964 · N7695T · Substantial damage NTSB UNK64X3972Accident · No injuriesClosedPiper PA28 · Roselle, ILSep 13, 1964 · N5085W · Substantial damage NTSB UNK64X3959Accident · No injuriesClosedCessna 195B · Richton Park, ILSep 13, 1964 · N3025B · Substantial damage