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 CHI67F0066Accident · Serious injuriesClosedPiper PA-24 · Grayslake, ILFeb 26, 1966 · N5917P · Destroyed NTSB CHI66D0642Accident · No injuriesClosedPiper PA-28 · Lombard, ILFeb 26, 1966 · N9098W · Substantial damage NTSB CHI66I0070Incident · 1 fatalClosedBritish AC 1-11 · Chicago, ILFeb 25, 1966 · N1547 · No damage NTSB CHI66D0626Accident · No injuriesClosedCessna 150 · E St Louis, ILFeb 20, 1966 · N3988U · Substantial damage NTSB CHI67F0062Accident · No injuriesClosedPiper PA-23 · East St Louis, ILFeb 19, 1966 · N2153P · Substantial damage NTSB CHI66F0589Accident · No injuriesClosedCessna 150 · Winnebago, ILFeb 19, 1966 · N8783S · Substantial damage NTSB CHI66F0625Accident · No injuriesClosedCessna 210D · East Alton, ILFeb 17, 1966 · N3939Y · Substantial damage NTSB CHI66F0606Accident · Minor injuriesClosedCessna 150B · Millstadt, ILFeb 13, 1966 · N7334X · Substantial damage NTSB CHI66F0644Accident · No injuriesClosedPiper PA-23 · Elgin, ILFeb 12, 1966 · N4255P · Substantial damage NTSB CHI66F0585Accident · No injuriesClosedAeronca 7AC · E St Louis, ILFeb 12, 1966 · N85759 · Substantial damage NTSB CHI66A0067Accident · 2 fatalClosedBeech D35 · Mattoon, ILFeb 8, 1966 · N112U · Destroyed NTSB CHI66D0641Accident · No injuriesClosedPiper PA-28 · Rockford, ILFeb 5, 1966 · N5135W · Substantial damage NTSB CHI66D0636Accident · No injuriesClosedPiper PA-12 · Roselle, ILFeb 5, 1966 · N7613H · Substantial damage NTSB CHI66F0582Accident · No injuriesClosedCessna 150E · E St Louis, ILFeb 4, 1966 · N3984U · Substantial damage NTSB CHI66F0580Accident · No injuriesClosedCessna 140 · Sycamore, ILFeb 4, 1966 · N81093 · Substantial damage NTSB CHI67F0316Accident · No injuriesClosedPiper PA-28 · Decatur, ILFeb 3, 1966 · N8904J · Substantial damage NTSB CHI66F0628Accident · No injuriesClosedPiper PA-12 · Rockford, ILFeb 2, 1966 · N92732 · Substantial damage NTSB CHI66F0653Accident · Serious injuriesClosedBeech B50 · Waukegan, ILFeb 1, 1966 · N3660B · Destroyed NTSB CHI66F0600Accident · No injuriesClosedPiper PA-22 · Naperville, ILJan 29, 1966 · N4785A · Substantial damage NTSB CHI66A0064Accident · No injuriesClosedCessna 310G · Chicago, ILJan 29, 1966 · N2932R · Substantial damage NTSB CHI66D0566Accident · No injuriesClosedCessna 172 · Chicago, ILJan 27, 1966 · N2112Y · Substantial damage NTSB CHI66F0611Accident · No injuriesClosedBeechcraft 23 · E Alton, ILJan 25, 1966 · N2367L · Substantial damage NTSB CHI66F0555Accident · No injuriesClosedCessna 150 · West Chicago, ILJan 25, 1966 · N3516L · Substantial damage NTSB CHI66F0656Accident · No injuriesClosedCessna 320D · Wheeling, ILJan 23, 1966 · N4148T · Substantial damage NTSB CHI66F0544Accident · No injuriesClosedBeechcraft C35 · Kankakee, ILJan 23, 1966 · N8944A · Substantial damage NTSB CHI66A0063Accident · 5 fatalClosedPiper PA-22 · Rockton, ILJan 23, 1966 · N2712P · 2 aircraft · Destroyed NTSB CHI66F0556Accident · No injuriesClosedBeechcraft P35 · Joliet, ILJan 21, 1966 · N1509S · Substantial damage NTSB CHI66F0613Accident · No injuriesClosedBeechcraft 95-55 · Wheeling, ILJan 20, 1966 · N6127V · Substantial damage NTSB CHI66D0575Accident · No injuriesClosedDehavilland 104-6A · Chicago, ILJan 17, 1966 · N4041B · Substantial damage NTSB CHI66D0520Accident · No injuriesClosedPiper PA-22 · Lombard, ILJan 16, 1966 · N5472Z · Substantial damage NTSB CHI66F0576Accident · Serious injuriesClosedPiper PA-28 · Columbia, ILJan 15, 1966 · N5835W · Destroyed NTSB CHI66F0558Accident · No injuriesClosedCessna 150 · Lombard, ILJan 15, 1966 · N3514J · Substantial damage NTSB CHI66F0542Accident · No injuriesClosedBeechcraft A23 · Cahokia, ILJan 15, 1966 · N1443L · Substantial damage NTSB CHI66F0622Accident · No injuriesClosedCessna 150 · Jacksonville, ILJan 11, 1966 · N8220S · Substantial damage NTSB CHI66F0543Accident · No injuriesClosedBeechcraft 23 · Joliet, ILJan 8, 1966 · N2328J · Substantial damage NTSB CHI66F0527Accident · No injuriesClosedCessna 150 · E Alton, ILJan 4, 1966 · N3988U · Substantial damage NTSB CHI66F0565Accident · No injuriesClosedBeechcraft E18S · Chicago, ILJan 3, 1966 · N426SF · Substantial damage NTSB CHI66F0509Accident · No injuriesClosedMooney M20B · Springfield, ILDec 31, 1965 · N74707 · Substantial damage NTSB CHI66F0552Accident · No injuriesClosedCessna 150 · West Chicago, ILDec 29, 1965 · N4119U · Substantial damage NTSB CHI66D0499Accident · No injuriesClosedCessna 150 · Farmington, ILDec 27, 1965 · N5939T · Substantial damage NTSB CHI66F0511Accident · No injuriesClosedCessna 172G · Streator, ILDec 26, 1965 · N3605L · Substantial damage NTSB CHI66D0503Accident · No injuriesClosedCessna 150 · East Alton, ILDec 26, 1965 · N8302G · Substantial damage NTSB CHI66F0533Accident · No injuriesClosedBeechcraft K35 · Chicago, ILDec 18, 1965 · N635Q · Substantial damage NTSB CHI66F0485Accident · Serious injuriesClosedPiper PA28 · Urbana, ILDec 18, 1965 · N8208W · Destroyed NTSB CHI66D0553Accident · No injuriesClosedMooney M20 · Polo, ILDec 18, 1965 · N6455U · Substantial damage NTSB CHI66F0528Accident · Minor injuriesClosedCessna 172 · Granite City, ILDec 16, 1965 · N5435T · Destroyed NTSB CHI66D0618Accident · No injuriesClosedCessna 182 · Meyer, ILDec 16, 1965 · N3419S · Substantial damage NTSB CHI66F0482Accident · No injuriesClosedPiper PA-28 · Lombard, ILDec 6, 1965 · N6774W · Substantial damage NTSB CHI66F0531Accident · Serious injuriesClosedBeechcraft 23 · Wheeling, ILDec 5, 1965 · N2323Q · 2 aircraft · Substantial damage NTSB CHI66F0479Accident · No injuriesClosedPiper PA-22 · Granite City, ILDec 4, 1965 · N8875D · Substantial damage