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 CHI67D0288Accident · Minor injuriesClosedCessna 175 · Hinsdale, ILJul 24, 1966 · N7202M · Substantial damage NTSB CHI67A0010Accident · No injuriesClosedBrantly B-2 · Washington, ILJul 23, 1966 · N2130U · Destroyed NTSB CHI67F0302Accident · 1 fatalClosedPiper PA-18A · Sandwich, ILJul 19, 1966 · N7192D · Destroyed NTSB CHI67D0261Accident · No injuriesClosedBeech A35 · Chicago, ILJul 19, 1966 · N733B · Substantial damage NTSB CHI67F0131Accident · No injuriesClosedCessna 180 · Sparta, ILJul 17, 1966 · N9371T · Destroyed NTSB CHI67A0007Accident · No injuriesClosedDouglas DC-3 · Peoria, ILJul 17, 1966 · N52935 · Substantial damage NTSB CHI67F0118Accident · Serious injuriesClosedCessna 172 · Dekalb, ILJul 16, 1966 · N6917A · Substantial damage NTSB CHI67D0212Accident · No injuriesClosedStinson 10A · Rockton, ILJul 16, 1966 · N32218 · Substantial damage NTSB CHI67D0213Accident · No injuriesClosedTemco D-16 · Waukegan, ILJul 15, 1966 · N712T · Substantial damage NTSB CHI67F0360Accident · No injuriesClosedBeech A35 · Wheeling, ILJul 14, 1966 · N794B · Destroyed NTSB CHI67D0069Accident · No injuriesClosedBeech A23 · Roselle, ILJul 12, 1966 · N3538R · Substantial damage NTSB CHI67D0219Accident · No injuriesClosedStinson 108 · Grays Lake, ILJul 10, 1966 · N39468 · Substantial damage NTSB CHI67F0161Accident · No injuriesClosedCessna 150 · Kankakee, ILJul 9, 1966 · N1146Y · 2 aircraft · Substantial damage NTSB CHI67D0061Accident · No injuriesClosedCessna 172D · Northbrook, ILJul 7, 1966 · N2971D · Substantial damage NTSB CHI67F0325Accident · No injuriesClosedCessna 170B · Hoopeston, ILJul 6, 1966 · N8097A · Substantial damage NTSB CHI67D0073Accident · No injuriesClosedPiper PA-22 · Patoka, ILJul 4, 1966 · N5057Z · Substantial damage NTSB CHI67D0070Accident · No injuriesClosedPiper PA-22 · Rockford, ILJul 2, 1966 · N5328Z · Substantial damage NTSB CHI67F0101Accident · No injuriesClosedBeech 35-C33 · Joliet, ILJul 1, 1966 · N5923S · Substantial damage NTSB CHI67F0163Accident · No injuriesClosedBeech 95 · Joliet, ILJun 29, 1966 · N2714Y · Substantial damage NTSB CHI67F0037Accident · No injuriesClosedBeech B23 · Joliet, ILJun 29, 1966 · N2328J · Substantial damage NTSB CHI67D0065Accident · No injuriesClosedAeronca 7AC · Weathersfield, ILJun 29, 1966 · N84065 · Substantial damage NTSB CHI66A0102Accident · 4 fatalClosedAero Comdr 200D · Chicago, ILJun 29, 1966 · N2911T · Destroyed NTSB CHI67D0098Accident · No injuriesClosedBellanca 14-19 · Belleville, ILJun 28, 1966 · N8506R · Substantial damage NTSB CHI67F0099Accident · No injuriesClosedCessna 150 · East St.Louis, ILJun 23, 1966 · N7973F · Substantial damage NTSB CHI67F0040Accident · No injuriesClosedCessna 182 · West Chicago, ILJun 23, 1966 · N2869F · Substantial damage NTSB CHI67D0211Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 22, 1966 · N8022S · Substantial damage NTSB CHI66A0100Accident · No injuriesClosedConvair CV-440 · Chicago, ILJun 17, 1966 · N2044 · Substantial damage NTSB CHI66A0098Accident · 6 fatalClosedPiper PA-24 · Alexis, ILJun 15, 1966 · N8929P · Destroyed NTSB CHI67F0056Accident · No injuriesClosedCessna 172G · Columbia, ILJun 14, 1966 · N3969L · Substantial damage NTSB CHI67F0042Accident · No injuriesClosedCessna 150F · E St Louis, ILJun 14, 1966 · N7944F · Substantial damage NTSB CHI67F0058Accident · No injuriesClosedCessna 310H · Moline, ILJun 13, 1966 · N1141Q · Substantial damage NTSB CHI67F0123Accident · No injuriesClosedTaylorcraft BC12D · Lombard, ILJun 11, 1966 · N96275 · Substantial damage NTSB CHI66A0096Accident · No injuriesClosedHughes 269A · Hinsdale, ILJun 8, 1966 · N8778F · Substantial damage NTSB CHI67D0324Accident · No injuriesClosedCessna 182 · Chicago, ILJun 2, 1966 · N2860F · Substantial damage NTSB CHI66F0785Accident · No injuriesClosedBeech N35 · Lincoln, ILMay 31, 1966 · N1298Z · Substantial damage NTSB CHI67D0024Accident · No injuriesClosedCessna 210A · Crestwood, ILMay 30, 1966 · N9487X · Substantial damage NTSB CHI66F0786Accident · Minor injuriesClosedCessna 182 · Antioch, ILMay 29, 1966 · N6361A · Substantial damage NTSB CHI66F0764Accident · No injuriesClosedLuscombe 8E · Cahokia, ILMay 29, 1966 · N1829K · Substantial damage NTSB CHI67F0046|CHI66F0046Accident · Minor injuriesClosedPiper J3 · Hinsdale, ILMay 26, 1966 · N35333 · 2 aircraft · Destroyed NTSB CHI67D0005Accident · No injuriesClosedBeech 95 · Chicago, ILMay 26, 1966 · N232H · Substantial damage NTSB CHI67D0001Accident · No injuriesClosedPiper PA-16 · Chicago, ILMay 26, 1966 · N5631H · Substantial damage NTSB CHI67D0023Accident · No injuriesClosedPiper PA-28 · Cordova, ILMay 25, 1966 · N7255W · Substantial damage NTSB CHI66A0091Accident · 1 fatalClosedBeech S35 · Monticello, ILMay 24, 1966 · N5842S · Destroyed NTSB CHI66A0090Accident · 1 fatalClosedRyan ST-3KR · St.Charles, ILMay 21, 1966 · N60155 · Destroyed NTSB CHI66F0761Accident · No injuriesClosedPiper PA-32 · Decatur, ILMay 19, 1966 · N3462W · Substantial damage NTSB CHI67F0003Accident · No injuriesClosedCessna 320 · Chicago, ILMay 18, 1966 · N5783X · Substantial damage NTSB CHI67D0205Accident · Minor injuriesClosedChampion 7EC · Urbana, ILMay 16, 1966 · N9904Y · Substantial damage NTSB CHI67F0112Accident · No injuriesClosedPiper PA-20 · Wheeling, ILMay 15, 1966 · N7621K · 2 aircraft · Substantial damage NTSB CHI67F0228Accident · Minor injuriesClosedBeech B55 · Wheeling, ILMay 10, 1966 · N5636K · 2 aircraft · Substantial damage NTSB CHI66F0733Accident · No injuriesClosedPiper PA-22 · Rockford, ILMay 9, 1966 · N7613D · Substantial damage