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 CHI75FEE03Accident · Serious injuriesClosedNavion B · Blue Island, ILJul 20, 1974 · N61Y · Substantial damage NTSB CHI75FEE01Accident · No injuriesClosedPiper PA-28 · West Chicago, ILJul 14, 1974 · N15003 · Substantial damage NTSB CHI75FEE04Accident · Minor injuriesClosedEmeraude CP301 · Elgin, ILJul 13, 1974 · N4825 · Destroyed NTSB CHI75FEE02Accident · Serious injuriesClosedBeech E18S · Lansing, ILJul 13, 1974 · N330DW · Substantial damage NTSB CHI75AC006Accident · 1 fatalClosedPiper PA-28 · Columbia, ILJul 10, 1974 · N5291W · Destroyed NTSB CHI75AC005Accident · Serious injuriesClosedBoeing 727 · Chicago, ILJul 10, 1974 · N6818 · No damage NTSB CHI74FEV57Accident · No injuriesClosedPiper PA-31 · Urbana, ILJun 29, 1974 · N9113Y · Substantial damage NTSB CHI74FEE87Accident · No injuriesClosedBrantly B2B · Wheeling, ILJun 25, 1974 · N2173U · Substantial damage NTSB CHI74FCA03Accident · No injuriesClosedSchweizer 1-26D · Highland, ILJun 24, 1974 · N7727S · Substantial damage NTSB CHI74AC098Accident · Serious injuriesClosedPiper PA-28 · Hampshire, ILJun 23, 1974 · N8282N · 2 aircraft · Substantial damage NTSB CHI74DEV56Accident · No injuriesClosedCessna 172 · Peoria, ILJun 20, 1974 · N3827S · Substantial damage NTSB CHI74AC097Accident · Minor injuriesClosedCessna 120 · Manito, ILJun 18, 1974 · N1762N · 2 aircraft · Destroyed NTSB CHI74FEE84Accident · No injuriesClosedCanadair T-33 · Bradford, ILJun 14, 1974 · N4TM · Substantial damage NTSB CHI74FEE85Accident · No injuriesClosedCessna 310G · Joliet, ILJun 12, 1974 · N8942Z · Substantial damage NTSB CHI74FEE83Accident · No injuriesClosedCessna 172N · Rock Falls, ILJun 6, 1974 · N19975 · Destroyed NTSB CHI74DEE82Accident · No injuriesClosedCessna 305 · Huntley, ILJun 1, 1974 · N5285G · Substantial damage NTSB CHI74FEV55Accident · Minor injuriesClosedBrantly B-2 · Atterbury, ILMay 29, 1974 · N5912X · Substantial damage NTSB CHI74FEV53Accident · Serious injuriesClosedMooney M20C · Watseka, ILMay 27, 1974 · N9251M · Minor damage NTSB CHI74DEE79Accident · No injuriesClosedCessna 150 · Frankfort, ILMay 27, 1974 · N6820G · Substantial damage NTSB CHI74FEE78Accident · No injuriesClosedCessna 172 · Rochelle, ILMay 26, 1974 · N46194 · Substantial damage NTSB CHI74FEE77Accident · Minor injuriesClosedCessna 172K · Schaumberg, ILMay 26, 1974 · N78418 · Substantial damage NTSB CHI74FEE80Accident · No injuriesClosedCessna 172L · Sugar Grove, ILMay 25, 1974 · N9823G · Substantial damage NTSB DCA74AZ021Accident · 4 fatalClosedLockheed 382 · Springfield, ILMay 23, 1974 · N14ST · Destroyed NTSB CHI74FEV54Accident · No injuriesClosedPiper PA-28 · Springfield, ILMay 23, 1974 · N6573J · Substantial damage NTSB CHI74FEE81Accident · No injuriesClosedMooney M20G · Tampico, ILMay 23, 1974 · N6835N · Substantial damage NTSB CHI74FEV52Accident · Serious injuriesClosedCessna 182L · Salem, ILMay 21, 1974 · N3112R · Substantial damage NTSB CHI74FEV50Accident · No injuriesClosedCessna 120 · Macomb, ILMay 19, 1974 · N3157N · Substantial damage NTSB CHI74IC091Incident · No injuriesClosedSwearingen SA226T · Chicago, ILMay 16, 1974 · N423S · Minor damage NTSB CHI74IC090Incident · No injuriesClosedDouglas DC-10 · Earlville, ILMay 14, 1974 · N106AA · Minor damage NTSB CHI74FEE72Accident · Minor injuriesClosedCessna 182 · Lansing, ILMay 4, 1974 · N8797T · Substantial damage NTSB CHI74FEE75Accident · Minor injuriesClosedCessna 172M · Waukegan, ILMay 3, 1974 · N4381R · Substantial damage NTSB CHI74FEE73Accident · No injuriesClosedCessna T210F · Chicago, ILMay 2, 1974 · N376KV · Substantial damage NTSB CHI74FEV49Accident · No injuriesClosedHiller Acft UH-12A · Springfield, ILMay 1, 1974 · N7636B · Substantial damage NTSB CHI74FEV47Accident · No injuriesClosedBeech 65 · Springfield, ILApr 27, 1974 · N14GF · Substantial damage NTSB CHI74DEE70Accident · Minor injuriesClosedErco 415-CD · Dekalb, ILApr 27, 1974 · N99214 · Substantial damage NTSB CHI74DEE71Accident · No injuriesClosedPiper PA-28 · Sandwich, ILApr 26, 1974 · N459FL · Substantial damage NTSB CHI74FEE68Accident · No injuriesClosedPiper PA-22 · Grayslake, ILApr 24, 1974 · N8734C · Destroyed NTSB CHI74DEE74Accident · No injuriesClosedCessna 185E · Minooka, ILApr 24, 1974 · N1586F · Substantial damage NTSB CHI74FEV46Accident · No injuriesClosedPiper PA-23 · Sparta, ILApr 22, 1974 · N3259P · Substantial damage NTSB CHI74FEE67Accident · No injuriesClosedBeech B19 · Joliet, ILApr 20, 1974 · N1922W · Substantial damage NTSB CHI74DEE69Accident · No injuriesClosedPiper PA-12 · Harvard, ILApr 20, 1974 · N4225M · Substantial damage NTSB CHI74FEV45Accident · No injuriesClosedBeech M35 · Mattoon, ILApr 19, 1974 · N9323Y · Substantial damage NTSB CHI74FEE66Accident · No injuriesClosedPiper PA-30 · Lansing, ILApr 17, 1974 · N7536Y · Substantial damage NTSB CHI74FEV44Accident · Serious injuriesClosedCessna A188B · Grayville, ILApr 16, 1974 · N21730 · Destroyed NTSB CHI74FEV34Accident · No injuriesClosedBeech A23 · Danville, ILApr 16, 1974 · N7932L · Substantial damage NTSB CHI74FEE65Accident · No injuriesClosedPiper PA-22 · Monee, ILApr 8, 1974 · N2563A · Substantial damage NTSB CHI74FEE64Accident · Minor injuriesClosedPiper PA-32 · Aurora, ILApr 7, 1974 · N4894S · Substantial damage NTSB CHI74FCA02Accident · No injuriesClosedCessna 210J · Livingston, ILApr 3, 1974 · N3309S · Substantial damage NTSB CHI74DEE76Accident · No injuriesClosedPiper PA-28 · Plainfield, ILMar 31, 1974 · N17079 · Substantial damage NTSB CHI74FEV42Accident · No injuriesClosedPiper PA-28 · Savoy, ILMar 27, 1974 · N8710N · Substantial damage