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 CHI70F0265Accident · Serious injuriesClosedPiper PA-18 · Columbia, ILAug 9, 1969 · N3581Z · Substantial damage NTSB CHI70F0205Accident · No injuriesClosedCessna 140 · Mt.Vernon, ILAug 5, 1969 · N2010N · Substantial damage NTSB CHI70F0173Accident · Serious injuriesClosedPiper PA-25 · Cherry Valley, ILAug 5, 1969 · N4718Y · Destroyed NTSB CHI70F0139Accident · No injuriesClosedCessna 150G · Springfield, ILAug 4, 1969 · N3276J · Substantial damage NTSB CHI70F0152Accident · No injuriesClosedPiper PA-28 · Bunker Hill, ILAug 2, 1969 · N9178W · Substantial damage NTSB CHI70D0185Accident · No injuriesClosedLuscombe 8E · Addison, ILJul 31, 1969 · N1557B · Substantial damage NTSB CHI70D0142Accident · No injuriesClosedPiper PA-22 · Manhattan, ILJul 31, 1969 · N5732Z · Substantial damage NTSB CHI70D0134Accident · No injuriesClosedCessna 172 · Marseilles, ILJul 30, 1969 · N79209 · Substantial damage NTSB CHI70D0190Accident · No injuriesClosedPiper PA-24 · Aledo, ILJul 27, 1969 · N6812P · Substantial damage NTSB CHI70F0300Accident · No injuriesClosedHughes 269A · Lexington, ILJul 26, 1969 · N8769F · Substantial damage NTSB CHI70D0322Accident · No injuriesClosedPiper PA-24 · Lansing, ILJul 26, 1969 · N7021P · Substantial damage NTSB CHI70F0174Accident · No injuriesClosedPiper PA-28 · Haldane, ILJul 25, 1969 · N7754W · Substantial damage NTSB CHI70A0006Accident · 3 fatalClosedCessna 172I · Barrington, ILJul 18, 1969 · N35777 · Destroyed NTSB CHI70F0158Accident · Serious injuriesClosedCessna 120 · Pecatonica, ILJul 11, 1969 · N76722 · Substantial damage NTSB CHI70D0177Accident · No injuriesClosedBeech A23A · Wheeling, ILJul 11, 1969 · N2322W · Substantial damage NTSB CHI70F0210Accident · Serious injuriesClosedCessna 172I · Northbrook, ILJul 10, 1969 · N35541 · Destroyed NTSB CHI70F0167Accident · Serious injuriesClosedPiper PA-28 · Lansing, ILJul 10, 1969 · N7346J · Substantial damage NTSB CHI70A0004Accident · 1 fatalClosedBeech D55 · Rockford, ILJul 8, 1969 · N7884R · Destroyed NTSB CHI70F0257Accident · No injuriesClosedCessna T-50 · Buffalo, ILJul 4, 1969 · N64056 · Substantial damage NTSB CHI70A0002Accident · 1 fatalClosedCessna 150 · Odell, ILJul 3, 1969 · N7156X · Destroyed NTSB CHI70D0085Accident · No injuriesClosedPiper PA-22 · Addison, ILJul 1, 1969 · N5822Z · Substantial damage NTSB CHI70D0143Accident · No injuriesClosedPiper PA-22 · Peotone, ILJun 28, 1969 · N6746B · Substantial damage NTSB CHI70F0055Accident · No injuriesClosedPiper PA-32 · Chicago, ILJun 27, 1969 · N5581J · Substantial damage NTSB CHI70D0074Accident · No injuriesClosedPiper PA-28 · Aledo, ILJun 27, 1969 · N7707N · Substantial damage NTSB CHI69A0103Accident · Serious injuriesClosedBoeing 727 · Chicago, ILJun 25, 1969 · N854TW · Substantial damage NTSB CHI70F0157Accident · No injuriesClosedBell 47G-5 · Dekalb, ILJun 21, 1969 · N8558F · Substantial damage NTSB CHI69A0101Accident · 1 fatalClosedLuscombe 8A · Rockford, ILJun 20, 1969 · N71362 · Destroyed NTSB CHI70F0111Accident · 1 fatalClosedPiper PA-28 · Grayslake, ILJun 17, 1969 · N6788W · Destroyed NTSB CHI70D0054Accident · No injuriesClosedPiper PA-28 · Elburn, ILJun 15, 1969 · N1721J · Substantial damage NTSB CHI70F0106Accident · Serious injuriesClosedPiper PA-28 · Champaign, ILJun 14, 1969 · N8476W · Destroyed NTSB CHI70F0179Accident · Minor injuriesClosedPiper PA-22 · Urbana, ILJun 12, 1969 · N7048B · Substantial damage NTSB CHI70F0034Accident · No injuriesClosedPiper PA-22 · Peoria, ILJun 10, 1969 · N962A · Substantial damage NTSB CHI70D0032Accident · No injuriesClosedCessna 150 · Minooka, ILJun 10, 1969 · N8382G · Substantial damage NTSB CHI70D0025Accident · No injuriesClosedPiper PA-28 · Hinsdale, ILJun 9, 1969 · N7347J · Substantial damage NTSB CHI70F0067Accident · Minor injuriesClosedStinson 108 · Lombard, ILJun 8, 1969 · N8941K · Substantial damage NTSB CHI69A0099Accident · 1 fatalClosedCessna 170B · Sparta, ILJun 7, 1969 · N2791C · Destroyed NTSB CHI70F0246Accident · No injuriesClosedBeech J35 · Lombard, ILJun 3, 1969 · N618Q · Substantial damage NTSB CHI70D0121Accident · No injuriesClosedPiper PA-28 · Sparta, ILJun 3, 1969 · N6847W · Substantial damage NTSB CHI70F0078Accident · Minor injuriesClosedCessna 140 · Jacksonville, ILJun 2, 1969 · N274 · Destroyed NTSB CHI70D0031Accident · No injuriesClosedStinson 10A · Crystal Lake, ILMay 30, 1969 · N26448 · Substantial damage NTSB CHI70F0022Accident · Minor injuriesClosedCessna 170A · Carbondale, ILMay 29, 1969 · N5486C · Substantial damage NTSB CHI70D0126Accident · No injuriesClosedPiper PA-28 · Monee, ILMay 29, 1969 · N7352J · Substantial damage NTSB CHI70F0088Accident · No injuriesClosedPiper PA-28 · Monticello, ILMay 28, 1969 · N8250N · Substantial damage NTSB CHI70D0026Accident · Minor injuriesClosedLuscombe 8F · Lockport, ILMay 27, 1969 · N1881B · Substantial damage NTSB CHI69F0660Accident · No injuriesClosedCessna 172K · Sycamore, ILMay 25, 1969 · N46599 · Substantial damage NTSB CHI70F0041Accident · Serious injuriesClosedSchweizer SGS126 · Tolono, ILMay 24, 1969 · N10137 · Substantial damage NTSB CHI70D0133Accident · Serious injuriesClosedSchweizer SGS123 · Naperville, ILMay 24, 1969 · N10377 · Substantial damage NTSB CHI70D0073Accident · Minor injuriesClosedCessna 140 · Paris, ILMay 23, 1969 · N2293N · Substantial damage NTSB CHI69D0666Accident · No injuriesClosedPiper PA-28 · Grayslake, ILMay 23, 1969 · N8282N · Substantial damage NTSB CHI69D0647Accident · No injuriesClosedCessna 150H · Lombard, ILMay 23, 1969 · N22757 · Substantial damage