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 CHI66F0229Accident · No injuriesClosedPiper PA-22 · Hinckley, ILAug 12, 1965 · N6023D · Substantial damage NTSB CHI66F0212Accident · No injuriesClosedCessna 210 · Morris, ILAug 12, 1965 · N7452E · Substantial damage NTSB CHI66F0181Accident · No injuriesClosedStinson 108-3 · Springfield, ILAug 12, 1965 · N726C · Substantial damage NTSB CHI66F0147Accident · No injuriesClosedPiper PA-22 · Warsaw, ILAug 7, 1965 · N4992Z · Substantial damage NTSB CHI66A0014Accident · 2 fatalClosedBeechcraft B35 · Peotone, ILAug 7, 1965 · N3365C · Destroyed NTSB CHI66D0410Accident · No injuriesClosedCessna 182 · Rockford, ILAug 6, 1965 · N3113Y · Substantial damage NTSB CHI66I0012Incident · No injuriesClosedBoeing 720B · Chicago, ILJul 31, 1965 · N723US · Minor damage NTSB CHI66F0160Accident · No injuriesClosedCessna 210 · Taylorville, ILJul 27, 1965 · N9608T · Substantial damage NTSB CHI66F0150Accident · No injuriesClosedPiper PA-28 · Roselle, ILJul 25, 1965 · N6843W · Substantial damage NTSB CHI66D0146Accident · No injuriesClosedPiper PA-24 · Lombard, ILJul 24, 1965 · N5778P · Substantial damage NTSB CHI66F0145Accident · No injuriesClosedPiper PA-30 · Wheeling, ILJul 23, 1965 · N7805Y · Substantial damage NTSB CHI66F0131Accident · No injuriesClosedCallair A-6 · Amboy, ILJul 22, 1965 · N9989C · Substantial damage NTSB CHI66F0118Accident · No injuriesClosedAeronca 058B · Champaign, ILJul 21, 1965 · N46924 · Substantial damage NTSB CHI66F0138Accident · No injuriesClosedSchweizer 2-22E · Oak Brook, ILJul 20, 1965 · N684U · Substantial damage NTSB CHI66F0109Accident · Minor injuriesClosedPiper PA-32 · Elgin, ILJul 20, 1965 · N3207W · Substantial damage NTSB CHI66F0115Accident · No injuriesClosedPiper PA-24 · Urbana, ILJul 19, 1965 · N7300P · Substantial damage NTSB CHI66I0008Incident · No injuriesClosedBoeing 727 · Chicago, ILJul 16, 1965 · N8118N · Minor damage NTSB CHI66F0107Accident · No injuriesClosedStinson 108-1 · Lombard, ILJul 11, 1965 · N880C · Substantial damage NTSB CHI66F0095Accident · 1 fatalClosedSmith Mini DSA-1 · Macomb, ILJul 11, 1965 · N21Z · Destroyed NTSB MKC66F0131Accident · Minor injuriesClosedCessna 182 · Belleville, ILJul 5, 1965 · N2539G · Destroyed NTSB CHI66F0106Accident · No injuriesClosedCessna 195 · Chicago, ILJul 5, 1965 · N9373A · Substantial damage NTSB CHI66D0108Accident · No injuriesClosedPiper PA-24 · Morris, ILJul 1, 1965 · N6877P · Substantial damage NTSB CHI66A0003Accident · 2 fatalClosedCessna 210 · Meppen, ILJun 30, 1965 · N6587X · Destroyed NTSB CHI65A0107Accident · Serious injuriesClosedBrantly B2 · Prophetstown, ILJun 28, 1965 · N2100U · Substantial damage NTSB CHI66F0085Accident · No injuriesClosedPiper PA-30 · Chicago, ILJun 24, 1965 · N7544Y · Substantial damage NTSB CHI66F0082Accident · No injuriesClosedPiper PA-24 · Sterling, ILJun 23, 1965 · N6274P · Substantial damage NTSB CHI66F0081Accident · No injuriesClosedCessna 172F · Polo, ILJun 12, 1965 · N5333R · Substantial damage NTSB CHI66F0061Accident · No injuriesClosedCessna 140 · East Moline, ILJun 12, 1965 · N1891V · Substantial damage NTSB CHI66D0053Accident · No injuriesClosedMooney M20C · Hillsboro, ILJun 12, 1965 · N6665R · Substantial damage NTSB CHI66F0469Accident · Minor injuriesClosedLuscombe 8A · East St Louis, ILJun 10, 1965 · N1407K · Substantial damage NTSB CHI66F0075Accident · No injuriesClosedPiper PA-22 · Elmwood, ILJun 10, 1965 · N4673Z · Substantial damage NTSB CHI66F0206Accident · No injuriesClosedCessna 140 · Joliet, ILJun 9, 1965 · N2353V · Substantial damage NTSB CHI66F0074Accident · No injuriesClosedPiper PA-20 · Galesburg, ILJun 6, 1965 · N7622K · Substantial damage NTSB CHI66F0059Accident · No injuriesClosedCessna 182 · Carbondale, ILJun 6, 1965 · N2215G · Substantial damage NTSB CHI66D0091Accident · No injuriesClosedPiper PA-28 · Pontiac, ILJun 5, 1965 · N5491W · Substantial damage NTSB CHI66F0055Accident · No injuriesClosedPiper PA-28 · Urbana, ILJun 4, 1965 · N6327W · Substantial damage NTSB CHI66F0026Accident · No injuriesClosedPiper PA-24 · Jacksonville, ILJun 4, 1965 · N8068P · Substantial damage NTSB CHI66F0041Accident · No injuriesClosedCessna 120 · Dixon, ILMay 31, 1965 · N3692V · Substantial damage NTSB CHI66F0140Accident · No injuriesClosedBeechcraft C-35 · Taylorville, ILMay 29, 1965 · N783D · Substantial damage NTSB CHI66F0029Accident · No injuriesClosedMooney M18C · Canton, ILMay 23, 1965 · N327M · Substantial damage NTSB CHI65F0194Accident · No injuriesClosedPiper PA-28 · Harvard, ILMay 21, 1965 · N6358W · Substantial damage NTSB CHI65A0097Accident · No injuriesClosedBeechcraft 35-B33 · Macomb, ILMay 21, 1965 · N8910M · Substantial damage NTSB CHI65F0201Accident · No injuriesClosedBeechcraft AT-11 · Chicago, ILMay 19, 1965 · N107RS · Substantial damage NTSB CHI65D0188Accident · No injuriesClosedPiper PA-22 · Benton, ILMay 16, 1965 · N3309Z · Substantial damage NTSB CHI66F0010Accident · No injuriesClosedCessna 170B · E St Louis, ILMay 13, 1965 · N3289A · Substantial damage NTSB CHI65F0202Accident · No injuriesClosedCessna 182B · Northbrook, ILMay 13, 1965 · N8445T · Substantial damage NTSB CHI65F0175Accident · Minor injuriesClosedPiper PA-22 · Monee, ILMay 8, 1965 · N4729Z · Substantial damage NTSB CHI65A0095Accident · Serious injuriesClosedConvair CV-880 · Chicago, ILMay 4, 1965 · N812TW · No damage NTSB CHI66F0031Accident · No injuriesClosedBeechcraft 95-55 · Peoria, ILMay 1, 1965 · N9335Y · Substantial damage NTSB CHI65F0197Accident · No injuriesClosedCessna 172 · Jerseyville, ILApr 30, 1965 · N5673T · Substantial damage