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 CHI75FEV11Accident · No injuriesClosedChampion 7GCAA · Shelbyville, ILNov 6, 1974 · N251JB · Substantial damage NTSB CHI75FCA01Accident · No injuriesClosedPiper PA-34 · Jacob, ILNov 3, 1974 · N2833T · Substantial damage NTSB CHI75FEE28Accident · No injuriesClosedCessna 182P · Chicago, ILOct 31, 1974 · N7248N · Substantial damage NTSB CHI75AC039Accident · No injuriesClosedCessna 421B · Rockford, ILOct 31, 1974 · N396DB · Substantial damage NTSB CHI75FEV09Accident · No injuriesClosedLuscombe 8A · Palmyra, ILOct 30, 1974 · N25127 · Substantial damage NTSB CHI75FEV10Accident · No injuriesClosedCessna 182H · Tuscola, ILOct 27, 1974 · N8331S · Substantial damage NTSB CHI75FEV08Accident · 1 fatalClosedJeanie TWO · Monticello, ILOct 27, 1974 · N109 · Destroyed NTSB CHI75DEE29Accident · No injuriesClosedCessna 150 · Frankfort, ILOct 27, 1974 · N18522 · Substantial damage NTSB CHI75AC035Accident · 2 fatalClosedCessna 337D · Chicago, ILOct 24, 1974 · N2HN · Substantial damage NTSB CHI75FEV07Accident · No injuriesClosedCessna 150 · Galatia, ILOct 15, 1974 · N3088X · Substantial damage NTSB CHI75DEE27Accident · No injuriesClosedSemco TC-4 · Harvard, ILOct 12, 1974 · N65248 · Substantial damage NTSB CHI75DEE25Accident · Serious injuriesClosedPiccard AX-6 · Harvard, ILOct 12, 1974 · N88US · No damage NTSB CHI75AC032Accident · 1 fatalClosedSemco AX-7 · Harvard, ILOct 12, 1974 · N14545 · Minor damage NTSB CHI75FEV06Accident · Serious injuriesClosedCessna 172K · Beason, ILOct 9, 1974 · N79468 · Minor damage NTSB CHI75AC030Accident · 2 fatalClosedCessna 150L · Morris, ILOct 8, 1974 · N19048 · Destroyed NTSB CHI75FEE24Accident · No injuriesClosedCessna 195A · Wheeling, ILOct 4, 1974 · N169CB · Substantial damage NTSB CHI75FEE26Accident · No injuriesClosedPiper PA-18 · Huntley, ILSep 29, 1974 · N6063V · Substantial damage NTSB CHI75AC029Accident · 2 fatalClosedPiper PA-28R · Crestwood, ILSep 29, 1974 · N9477N · Destroyed NTSB CHI75AC028Accident · 3 fatalClosedCessna 172K · Glendale Hts, ILSep 27, 1974 · N46568 · Destroyed NTSB CHI75FEE23Accident · No injuriesClosedBeech B19 · Waukegan, ILSep 25, 1974 · N24685 · Substantial damage NTSB CHI75FEV05Accident · No injuriesClosedPiper PA-34 · Olney, ILSep 20, 1974 · N55061 · Substantial damage NTSB CHI75FEV04Accident · Minor injuriesClosedCessna 120 · Carmi, ILSep 15, 1974 · N2224N · Substantial damage NTSB CHI75FEE21Accident · No injuriesClosedChampion 7ECA · Earlville, ILSep 15, 1974 · N8352V · Substantial damage NTSB CHI75FEE22Accident · No injuriesClosedCessna 182M · Channahon, ILSep 9, 1974 · N91552 · Substantial damage NTSB CHI75FEE20Accident · No injuriesClosedBeech 35-A33 · Frankfort, ILSep 8, 1974 · N897R · Substantial damage NTSB CHI75FCA02Accident · Serious injuriesClosedBaby Great Lakes · Columbia, ILSep 8, 1974 · N331DG · Destroyed NTSB CHI75FEE19Accident · Serious injuriesClosedPiper PA-28 · Elgin, ILSep 5, 1974 · N1403T · Substantial damage NTSB CHI75FEV03Accident · Minor injuriesClosedLuscombe 8E · Gillespie, ILSep 4, 1974 · N1829K · Substantial damage NTSB CHI75DEE18Accident · No injuriesClosedCessna 170B · Manteno, ILAug 31, 1974 · N2505C · Substantial damage NTSB CHI75FEE16Accident · No injuriesClosedBoeing E75 · Streator, ILAug 26, 1974 · N4593N · Substantial damage NTSB CHI75AC021Accident · 3 fatalClosedCessna 177 · New Lenox, ILAug 24, 1974 · N2802X · Substantial damage NTSB CHI75FEE14Accident · Minor injuriesClosedBell 47G5A · Hinsdale, ILAug 20, 1974 · N211CB · Substantial damage NTSB CHI75FEE12Accident · 1 fatalClosedPiper J3C-65 · Kankakee, ILAug 18, 1974 · N35258 · Destroyed NTSB CHI75AC018Accident · 2 fatalClosedPiper PA-28 · Donnellson, ILAug 18, 1974 · N42666 · Destroyed NTSB CHI75FEE17Accident · No injuriesClosedAlon A-2 · Waukegan, ILAug 17, 1974 · N5654F · Substantial damage NTSB CHI75IC016Incident · No injuriesClosedBeech B95A · West Chicago, ILAug 14, 1974 · N1247Z · Minor damage NTSB CHI75FEE10Accident · No injuriesClosedBeech P35 · West Chicago, ILAug 11, 1974 · N15707 · Substantial damage NTSB CHI75AC015Accident · 1 fatalClosedCessna 172F · Mayview, ILAug 11, 1974 · N5533R · Destroyed NTSB CHI75FEV02Accident · No injuriesClosedPiper PA-24 · Quincy, ILAug 9, 1974 · N9291P · Substantial damage NTSB CHI75FEE09Accident · No injuriesClosedAero Comdr 690A · Rockford, ILAug 8, 1974 · N690WC · Substantial damage NTSB CHI75FEE11Accident · No injuriesClosedBaby GR Lak 1SP · Midlothian, ILAug 5, 1974 · N132SP · Substantial damage NTSB CHI75DEV01Accident · No injuriesClosedMooney M20 · Mt Vernon, ILAug 4, 1974 · N99WK · Substantial damage NTSB CHI75IC013Incident · No injuriesClosedBoeing 727 · Chicago, ILAug 3, 1974 · N1643 · No damage NTSB CHI75FEE08Accident · No injuriesClosedPiper PA-30 · Chicago, ILAug 1, 1974 · N1188Y · Substantial damage NTSB CHI75FEE15Accident · No injuriesClosedCessna 172 · Ottawa, ILJul 30, 1974 · N7284Q · Substantial damage NTSB CHI75FEE05Accident · No injuriesClosedJurca P-51 · Blue Island, ILJul 28, 1974 · N51DR · Substantial damage NTSB CHI75FEE06Accident · No injuriesClosedCessna 150L · Lockport, ILJul 27, 1974 · N18534 · 2 aircraft · Substantial damage NTSB CHI75FEE07Accident · Serious injuriesClosedCessna 150L · Rockford, ILJul 26, 1974 · N1733Q · Destroyed NTSB CHI75AC010Accident · 2 fatalClosedPiper PA-30 · Urbana, ILJul 22, 1974 · N8724Y · Destroyed NTSB CHI75DEE13Accident · No injuriesClosedBeech 23-19A · Kankakee, ILJul 21, 1974 · N9035T · Substantial damage