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 CHI73FEV01Accident · No injuriesClosedPiper PA-28 · Oakwood, ILJul 2, 1972 · N2170R · Substantial damage NTSB CHI72FEE85Accident · 1 fatalClosedCessna T210L · Moline, ILJun 30, 1972 · N4691Q · Substantial damage NTSB CHI72DEE88Accident · No injuriesClosedMooney M20F · Ringwood, ILJun 29, 1972 · N9539M · Substantial damage NTSB CHI72FEE87Accident · Minor injuriesClosedGrumman G64A · Stillman Vly, ILJun 28, 1972 · N6598 · Substantial damage NTSB CHI72FEV36Accident · No injuriesClosedStits SA-3A · Pittsfield, ILJun 25, 1972 · N1039Z · 2 aircraft · Substantial damage NTSB CHI72DEE86Accident · No injuriesClosedSchweizer SGS1-2 · Naperville, ILJun 25, 1972 · N2712D · Substantial damage NTSB CHI72FEE89Accident · Minor injuriesClosedMooney M20C · Lansing, ILJun 20, 1972 · N7161U · Substantial damage NTSB CHI72FEE83Accident · No injuriesClosedPiper PA-30 · Elgin, ILJun 19, 1972 · N7612Y · Destroyed NTSB CHI72DEV34Accident · No injuriesClosedCessna 182L · Ullin, ILJun 16, 1972 · N42204 · Substantial damage NTSB CHI72FEE82Accident · 1 fatalClosedLowers Bird · Crystal Lake, ILJun 15, 1972 · N591T · Destroyed NTSB CHI73AC100Accident · No injuriesClosedDouglas DC-9 · Chicago, ILJun 14, 1972 · N8906E · Substantial damage NTSB CHI72FEE81Accident · No injuriesClosedCessna 150 · Joliet, ILJun 11, 1972 · N5463Q · Substantial damage NTSB CHI72FEE84Accident · Serious injuriesClosedPiper PA-24 · Chicago, ILJun 10, 1972 · N7883P · Minor damage NTSB CHI72AC094Accident · 4 fatalClosedPiper PA-24 · Ramsey, ILMay 28, 1972 · N5796P · Destroyed NTSB CHI72FEE80Accident · No injuriesClosedCessna 421B · Wheeling, ILMay 26, 1972 · N8002Q · Substantial damage NTSB CHI72DEV32Accident · No injuriesClosedBreezy RLU-1 · Batchtown, ILMay 25, 1972 · N581T · Substantial damage NTSB CHI72FEV35Accident · No injuriesClosedBell 47D1 · Fairfield, ILMay 20, 1972 · N7734 · Substantial damage NTSB CHI72FEV30Accident · No injuriesClosedPiper PA-24 · Paloma, ILMay 13, 1972 · N5236P · Substantial damage NTSB CHI72DEE79Accident · No injuriesClosedBoeing B75N1 · Northbrook, ILMay 12, 1972 · N75032 · Substantial damage NTSB CHI72DCA04Accident · Minor injuriesClosedTaylorcraft BF-60 · Cahokia, ILMay 12, 1972 · N23622 · Substantial damage NTSB CHI72FEV31Accident · Serious injuriesClosedBensen B8M · Bloomington, ILMay 10, 1972 · N30082 · Minor damage NTSB CHI72DEE78Accident · No injuriesClosedCessna 180 · Stockton, ILMay 10, 1972 · N6435A · Substantial damage NTSB CHI72FEV29Accident · No injuriesClosedStinson 10A · Macomb, ILMay 6, 1972 · N27719 · Substantial damage NTSB CHI72AC086Accident · No injuriesClosedBeech C-45G · Chicago, ILMay 2, 1972 · N3666G · Substantial damage NTSB CHI72FEE77Accident · No injuriesClosedPiper PA-23 · Spring Grove, ILApr 29, 1972 · N2173P · Substantial damage NTSB CHI72FEE75Accident · No injuriesClosedCessna 210G · Wheeling, ILApr 25, 1972 · N5819F · Substantial damage NTSB CHI72FEE74Accident · No injuriesClosedCessna 150G · Northbrook, ILApr 23, 1972 · N3135J · Substantial damage NTSB CHI72DEE76Accident · No injuriesClosedCessna 310B · Kankakee, ILApr 23, 1972 · N310V · Substantial damage NTSB CHI72FEE72Accident · 1 fatalClosedCassutt 11M · Naperville, ILApr 18, 1972 · N55MS · Destroyed NTSB CHI72DEV28Accident · No injuriesClosedPiper PA-28 · Urbana, ILApr 17, 1972 · N4393J · Substantial damage NTSB CHI72FEE73Accident · No injuriesClosedMooney M-20C · Northbrook, ILApr 13, 1972 · N6750U · Substantial damage NTSB CHI72DEV27Accident · No injuriesClosedPiper PA-30 · Urbana, ILApr 12, 1972 · N1188Y · Substantial damage NTSB CHI72DEE71Accident · No injuriesClosedMGT Mustang MM1 · Lockport, ILApr 9, 1972 · N8710 · Substantial damage NTSB CHI72DEE70Accident · No injuriesClosedLuscombe 8E · Rockton, ILApr 8, 1972 · N2351K · Substantial damage NTSB CHI72AC077Accident · 2 fatalClosedPiper PA-30 · Vandalia, ILMar 29, 1972 · N8543Y · Destroyed NTSB CHI72DEE68Accident · No injuriesClosedPiper PA-28 · Hinsdale, ILMar 19, 1972 · N5796F · Substantial damage NTSB CHI72DCA03Accident · No injuriesClosedChampion 7FC · Columbia, ILMar 19, 1972 · N7694E · Substantial damage NTSB CHI72FCA02Accident · Serious injuriesClosedBeech H35 · East St.Louis, ILMar 18, 1972 · N5529D · Substantial damage NTSB CHI72DEE69Accident · No injuriesClosedPiper PA-22 · East Moline, ILMar 18, 1972 · N4554A · Substantial damage NTSB CHI72AC074Accident · 2 fatalClosedCessna 150J · Quincy, ILMar 18, 1972 · N51092 · Destroyed NTSB CHI72FEE66Accident · Serious injuriesClosedBeech C50 · Waukegan, ILMar 16, 1972 · N3752B · Substantial damage NTSB CHI72AC071Accident · 3 fatalClosedCessna 172G · Orion, ILMar 12, 1972 · N4246L · Destroyed NTSB CHI72DEV26Accident · No injuriesClosedPiper PA-22 · Champaign, ILMar 11, 1972 · N5472Z · Substantial damage NTSB CHI72DEE67Accident · No injuriesClosedPiper PA-28 · Wheeling, ILMar 11, 1972 · N1862J · Substantial damage NTSB CHI72FEE60Accident · No injuriesClosedCessna 140 · Wheeling, ILMar 10, 1972 · N3552V · Substantial damage NTSB CHI72FEE64Accident · No injuriesClosedCessna 177 · Richton Park, ILMar 9, 1972 · N3259T · Destroyed NTSB CHI72DEV25Accident · No injuriesClosedCessna 172K · Robinson, ILMar 6, 1972 · N78733 · Substantial damage NTSB CHI72FEE59Accident · No injuriesClosedMooney M-20E · Northbrook, ILMar 5, 1972 · N2575W · Substantial damage NTSB CHI72FEV24Accident · No injuriesClosedPiper PA-28 · Decatur, ILFeb 29, 1972 · N2069T · Substantial damage NTSB CHI72DEE62Accident · No injuriesClosedPiper J-3 · Northbrook, ILFeb 29, 1972 · N42736 · Substantial damage