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 CHI74DEV41Accident · No injuriesClosedGrumman G-164A · Ware, ILMar 27, 1974 · N7248 · Substantial damage NTSB CHI74FEE62Accident · No injuriesClosedPiper PA-34 · Lansing, ILMar 25, 1974 · N5487T · Substantial damage NTSB CHI74FEE61Accident · No injuriesClosedPiper PA-28 · Tonica, ILMar 17, 1974 · N15533 · Substantial damage NTSB CHI74DEE63Accident · No injuriesClosedCessna 150 · Rochelle, ILMar 16, 1974 · N10488 · Substantial damage NTSB CHI74FEV40Accident · No injuriesClosedCessna 150 · Monticello, ILMar 13, 1974 · N6690G · Substantial damage NTSB CHI74FEE59Accident · No injuriesClosedCessna 182P · St.Charles, ILMar 10, 1974 · N111DL · Substantial damage NTSB CHI74DEE60Accident · No injuriesClosedAmer Avco AA1-B · Sugar Grove, ILMar 10, 1974 · N6543L · Substantial damage NTSB CHI74DEE57Accident · No injuriesClosedCessna 172H · Aurora, ILFeb 28, 1974 · N2413L · Substantial damage NTSB CHI74DEE56Accident · No injuriesClosedPiper PA-18 · Joliet, ILFeb 28, 1974 · N7690D · Substantial damage NTSB CHI74FEE55Accident · No injuriesClosedBellanca 7ECA · Naperville, ILFeb 26, 1974 · N8868 · Substantial damage NTSB CHI74DEE58Accident · No injuriesClosedPiper PA-32 · Dekalb, ILFeb 26, 1974 · N4803S · Substantial damage NTSB CHI74FEV39Accident · No injuriesClosedPiper PA-28R · Tuscola, ILFeb 24, 1974 · N5099S · Substantial damage NTSB CHI74AC072Accident · Serious injuriesClosedDouglas DC-9 · Pontiac, ILFeb 21, 1974 · N1262L · No damage NTSB CHI74DEE53Accident · No injuriesClosedBeech P35 · Wheeling, ILFeb 17, 1974 · N393T · Substantial damage NTSB CHI74DEE54Accident · No injuriesClosedPiper PA-28 · Kankakee, ILFeb 16, 1974 · N7443R · Substantial damage NTSB CHI74FEE51Accident · No injuriesClosedMitsubishi MU2B · Elgin, ILFeb 13, 1974 · N261WR · Substantial damage NTSB CHI74FEE52Accident · Minor injuriesClosedAero Comdr 112 · Rockford, ILFeb 5, 1974 · N1061J · Substantial damage NTSB CHI74AC067Accident · 2 fatalClosedBeech V35 · Dixon, ILFeb 4, 1974 · N3751Q · 2 aircraft · Destroyed NTSB CHI74DEE50Accident · No injuriesClosedPiper PA-23 · Wheeling, ILFeb 2, 1974 · N4430P · Substantial damage NTSB CHI74FEV38Accident · No injuriesClosedCessna 170B · Carlinville, ILJan 29, 1974 · N3004A · Substantial damage NTSB CHI74DEV37Accident · No injuriesClosedCessna 195B · Marion, ILJan 22, 1974 · N3025B · Substantial damage NTSB CHI74FEE49Accident · Serious injuriesClosedCessna 210G · Wheeling, ILJan 17, 1974 · N242ER · Substantial damage NTSB CHI74FEE48Accident · Serious injuriesClosedAmer Avco AA1 · Lincolnshire, ILJan 17, 1974 · N5954L · Substantial damage NTSB CHI74AC062Accident · 1 fatalClosedPiper PA-32 · Chicago, ILJan 17, 1974 · N3998W · Destroyed NTSB CHI74FEV35Accident · No injuriesClosedCessna 172L · Quincy, ILJan 14, 1974 · N9883G · Substantial damage NTSB CHI74DEV34Accident · No injuriesClosedCessna 150 · Pekin, ILJan 14, 1974 · N11570 · Substantial damage NTSB CHI74DEV36Accident · No injuriesClosedCessna 172M · Jerseyville, ILJan 13, 1974 · N13381 · Substantial damage NTSB CHI74FEE47Accident · No injuriesClosedCessna 310 · Wheeling, ILJan 12, 1974 · N671R · Substantial damage NTSB CHI74FEE46Accident · No injuriesClosedPiper PA-28 · Dekalb, ILJan 4, 1974 · N686FL · Substantial damage NTSB CHI74DEE41Accident · Minor injuriesClosedCessna 150 · Wheeling, ILDec 31, 1973 · N19277 · Substantial damage NTSB CHI74FEE44Accident · No injuriesClosedPiper PA-24 · Princeton, ILDec 30, 1973 · N6906P · Substantial damage NTSB CHI74DEE45Accident · No injuriesClosedCessna 150 · Lansing, ILDec 30, 1973 · N19240 · Substantial damage NTSB CHI74FEV31Accident · No injuriesClosedCessna P206 · Chillicothe, ILDec 29, 1973 · N2543X · Substantial damage NTSB CHI74DEV33Accident · No injuriesClosedPiper PA-28 · Decatur, ILDec 29, 1973 · N4770T · Substantial damage NTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILDec 28, 1973 · N2303W · Destroyed NTSB CHI74AC053Accident · No injuriesClosedBeech E18S · Chicago, ILDec 27, 1973 · N5612D · Substantial damage NTSB CHI74FEV32Accident · No injuriesClosedPiper PA-30 · Peoria, ILDec 23, 1973 · N7087Y · Substantial damage NTSB CHI74FEE42Accident · No injuriesClosedAmer Avco AA1 · Woodstock, ILDec 23, 1973 · N6152L · Substantial damage NTSB CHI74DEE38Accident · No injuriesClosedCessna 182F · Schaumberg, ILDec 23, 1973 · N3479U · Substantial damage NTSB CHI74AC052Accident · 2 fatalClosedCessna 182B · Claytonville, ILDec 23, 1973 · N7249E · Destroyed NTSB CHI74FEE37Accident · Serious injuriesClosedCessna TU206B · West Chicago, ILDec 22, 1973 · N3450L · Substantial damage NTSB CHI74DEE43Accident · No injuriesClosedStinson 108 · Kewanee, ILDec 20, 1973 · N8546K · Substantial damage NTSB CHI74DEE40Accident · No injuriesClosedCessna 150 · Rochelle, ILDec 20, 1973 · N10488 · Substantial damage NTSB CHI74AC049Accident · No injuriesClosedBeech E18S · Geneva, ILDec 13, 1973 · N503J · Substantial damage NTSB CHI74FEV30Accident · Serious injuriesClosedCessna P206 · Macomb, ILDec 12, 1973 · N2567X · Destroyed NTSB CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILDec 12, 1973 · N5796F · Substantial damage NTSB CHI74DEE35Accident · No injuriesClosedCessna 180 · Joliet, ILDec 2, 1973 · N3196C · Substantial damage NTSB CHI74FEV29Accident · No injuriesClosedCessna 150L · Laharpe, ILDec 1, 1973 · N1545Q · Substantial damage NTSB CHI74DEE35Accident · No injuriesClosedBeech 23-19 · Moline, ILNov 18, 1973 · N6091N · Substantial damage NTSB CHI74DEV28Accident · No injuriesClosedCessna T210F · Peoria, ILNov 17, 1973 · N6191R · Substantial damage