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 CHI73FEE52Accident · No injuriesClosedPiper PA-22 · Schaumburg, ILApr 7, 1973 · N5815Z · Substantial damage NTSB CHI73AC081Accident · 3 fatalClosedBeech 95-A55 · Midlothian, ILApr 7, 1973 · N9792Y · Destroyed NTSB CHI73FEE49Accident · Minor injuriesClosedPiper PA-28R · Elgin, ILApr 4, 1973 · N9430N · Destroyed NTSB CHI73AC078Accident · 1 fatalClosedDehavilland DHC-6 · Savoy, ILMar 26, 1973 · N7705 · Destroyed NTSB CHI73DEE48Accident · No injuriesClosedCessna 180 · Rochelle, ILMar 18, 1973 · N1781C · Substantial damage NTSB CHI73DEE47Accident · No injuriesClosedPiper PA-24 · Roselle, ILMar 18, 1973 · N6607P · Substantial damage NTSB CHI73AC074Accident · No injuriesClosedBeech C18S · Kewanee, ILMar 16, 1973 · N1171X · Substantial damage NTSB CHI73FEV24Accident · Minor injuriesClosedPiper PA-18A · Claremont, ILMar 13, 1973 · N1471C · Destroyed NTSB CHI73AEE46Accident · Minor injuriesClosedBeech V35 · Mount Morris, ILMar 8, 1973 · N2048W · Substantial damage NTSB CHI73DEV23Accident · No injuriesClosedPiper PA-22 · Vandalia, ILMar 4, 1973 · N5944Z · Substantial damage NTSB CHI73FCA03Accident · 1 fatalClosedRobertson T210L · Bethalto, ILMar 2, 1973 · N22458 · Destroyed NTSB CHI73FEY22Accident · Minor injuriesClosedCessna 175 · Geff, ILFeb 28, 1973 · N9293B · Substantial damage NTSB CHI73FCA04Accident · Serious injuriesClosedChampion 7KCAB · Chaokia, ILFeb 24, 1973 · N1888G · Destroyed NTSB CHI73 EE45Accident · No injuriesClosedPiper PA-28 · Freeport, ILFeb 22, 1973 · N6556J · Substantial damage NTSB CHI73DEE44Accident · No injuriesClosedCessna P206 · Dixon, ILFeb 17, 1973 · N2543X · Substantial damage NTSB CHI73AC068Accident · 2 fatalClosedCessna 150L · Morris, ILFeb 4, 1973 · N6974G · Destroyed NTSB CHI73FEV21Accident · Minor injuriesClosedCessna 150J · Marion, ILJan 30, 1973 · N61286 · Substantial damage NTSB CHI73FEE42Accident · No injuriesClosedPiper PA-23 · Schaumburg, ILJan 26, 1973 · N4371P · Substantial damage NTSB CHI73AC066Accident · 1 fatalClosedCessna 207 · Marion, ILJan 26, 1973 · N1582U · Destroyed NTSB CHI73FEE43Accident · No injuriesClosedBeech 58 · Hinsdale, ILJan 21, 1973 · N9437Q · Substantial damage NTSB CHI73DEE41Accident · No injuriesClosedPiper PA-28 · Joliet, ILJan 20, 1973 · N1786T · Substantial damage NTSB CHI73AC064Accident · No injuriesClosedBoeing 707 · Elk Grv Vllg, ILJan 20, 1973 · N8436 · Substantial damage NTSB CHI73FEV20Accident · Serious injuriesClosedCessna 150B · Peoria, ILJan 14, 1973 · N1244Y · Substantial damage NTSB CHI73FEE40Accident · No injuriesClosedPiper PA-28 · Elgin, ILJan 7, 1973 · N1403T · Substantial damage NTSB CHI73DEE39Accident · No injuriesClosedPiper PA-28 · Lansing, ILJan 4, 1973 · N7261F · Substantial damage NTSB CHI73FEV19Accident · Minor injuriesClosedCessna 150H · Albion, ILDec 29, 1972 · N50344 · Substantial damage NTSB CHI73FEE38Accident · No injuriesClosedCessna 150J · West Chicago, ILDec 28, 1972 · N106DP · Substantial damage NTSB CHI73FEE37Accident · No injuriesClosedBellanca 17-31 · Northbrook, ILDec 27, 1972 · N8830V · Substantial damage NTSB CHI73AC059Accident · 2 fatalClosedBeech H18S · Bloominton, ILDec 21, 1972 · N800G · Destroyed NTSB DCA73AZ004Accident · 10 fatalClosedConvair 880 · Chicago, ILDec 20, 1972 · N8807E · 2 aircraft · Substantial damage NTSB CHI73FEV18Accident · No injuriesClosedBeech D55 · Champaign, ILDec 19, 1972 · N7731R · Substantial damage NTSB CHI73FEE36Accident · No injuriesClosedCessna 500 · Chicago, ILDec 19, 1972 · N522JD · Substantial damage NTSB CHI73FEE35Accident · No injuriesClosedPiper PA-28 · Northbrook, ILDec 14, 1972 · N5393S · Substantial damage NTSB NYC73AN081Accident · 4 fatalClosedPiper PA-28 · Grand Tower, ILDec 8, 1972 · N4235T · Destroyed NTSB DCA73A0003Accident · 43 fatalClosedBoeing 737 · Chicago, ILDec 8, 1972 · N9031U · Destroyed NTSB CHI73FEE34Accident · No injuriesClosedPiper PA-23 · Joliet, ILDec 7, 1972 · N6500D · Substantial damage NTSB CHI73FEV17Accident · No injuriesClosedPiper PA-28R · Fairfield, ILNov 27, 1972 · N4663J · Substantial damage NTSB CHI73FEE32Accident · No injuriesClosedBeech 65-B80 · Rockford, ILNov 27, 1972 · N7813L · Substantial damage NTSB CHI73FEV16Accident · No injuriesClosedPiper PA-24 · Burnt Prairie, ILNov 26, 1972 · N5186P · Substantial damage NTSB CHI73ICO61Incident · No injuriesClosedConvair 580 · Chicago, ILNov 24, 1972 · N4810C · 2 aircraft · Minor damage NTSB CHI73DEE33Accident · No injuriesClosedPiper PA-22 · Lockport, ILNov 23, 1972 · N1170C · Substantial damage NTSB CHI73FEE31Accident · Minor injuriesClosedPiper PA-28 · Northbrook, ILNov 21, 1972 · N1790T · Substantial damage NTSB CHI73AC049Accident · 2 fatalClosedCessna 182E · Willisville, ILNov 21, 1972 · N9346X · Destroyed NTSB CHI73DCA02Accident · No injuriesClosedCessna 150H · Cahokia, ILNov 12, 1972 · N22473 · Substantial damage NTSB CHI73DEE30Accident · No injuriesClosedCessna 172K · Moline, ILNov 9, 1972 · N7409G · Substantial damage NTSB CHI73FEV15Accident · No injuriesClosedBeech 35 · Quincy, ILNov 5, 1972 · N3956N · Substantial damage NTSB CHI73FEE29Accident · Minor injuriesClosedPiper PA-22 · Barrington, ILNov 5, 1972 · N5751D · Substantial damage NTSB CHI73FEE28Accident · No injuriesClosedCessna 190 · Morris, ILNov 5, 1972 · N4361V · Destroyed NTSB CHI73FEE27Accident · No injuriesClosedCessna 150 · Geneva, ILOct 30, 1972 · N5356Q · Substantial damage NTSB CHI73FEV14Accident · No injuriesClosedPiper PA-30 · Robinson, ILOct 23, 1972 · N7939 · Substantial damage