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 CHI69F0333Accident · Serious injuriesClosedCessna 150 · Carmi, ILAug 14, 1968 · N6370S · Substantial damage NTSB CHI69F0199Accident · Serious injuriesClosedCessna 177 · E.St.Louis, ILAug 14, 1968 · N3389T · Destroyed NTSB CHI69A0018Accident · 2 fatalClosedLuscombe 8E · Barrington, ILAug 13, 1968 · N2998K · Destroyed NTSB CHI69F0164Accident · Minor injuriesClosedPiper PA-28 · Washington, ILAug 9, 1968 · N7118R · Substantial damage NTSB CHI69I0015Incident · No injuriesClosedConvair 880 · Chicago, ILAug 7, 1968 · N828TW · Minor damage NTSB CHI69D0259Accident · Minor injuriesClosedN American SNJ-5 · Sandwich, ILAug 4, 1968 · N7806B · Substantial damage NTSB CHI69D0173Accident · No injuriesClosedPiper PA-28 · Northbrook, ILAug 4, 1968 · N4709L · Substantial damage NTSB CHI69F0168Accident · No injuriesClosedNaval N3N · Galva, ILAug 2, 1968 · N45013 · Substantial damage NTSB CHI69I0016Incident · No injuriesClosedFairchild FH-227 · Champaign, ILAug 1, 1968 · N4219 · No damage NTSB CHI69D0193Accident · No injuriesClosedBeech A23 · Moline, ILAug 1, 1968 · N5771V · Substantial damage NTSB CHI69F0127Accident · Minor injuriesClosedBoeing B75N1 · Normandy, ILJul 31, 1968 · N79481 · Destroyed NTSB CHI69F0231Accident · Minor injuriesClosedDyke Delta JD-2 · Rockford, ILJul 29, 1968 · N555A · Substantial damage NTSB CHI69F0159Accident · No injuriesClosedCallair A-5 · Yates City, ILJul 28, 1968 · N2900G · Destroyed NTSB CHI69D0145Accident · No injuriesClosedBeech A23 · Chenoa, ILJul 28, 1968 · N6935Q · Substantial damage NTSB CHI69F0146Accident · No injuriesClosedCessna 182D · Macomb, ILJul 27, 1968 · N8980X · Substantial damage NTSB CHI69D0184Accident · No injuriesClosedCessna 150 · Wheeling, ILJul 27, 1968 · N8022S · Substantial damage NTSB CHI69A0010Accident · 3 fatalClosedFairchild 24 · Lombard, ILJul 27, 1968 · N92E · Destroyed NTSB CHI69F0178Accident · Minor injuriesClosedBoeing E75N1 · Lexington, ILJul 26, 1968 · N4810V · Destroyed NTSB CHI69F0133Accident · Minor injuriesClosedBoeing A75 · Minonk, ILJul 26, 1968 · N49954 · Substantial damage NTSB CHI69D0161Accident · No injuriesClosedCessna 210E · Northbrook, ILJul 24, 1968 · N2356F · Substantial damage NTSB CHI69F0115Accident · No injuriesClosedBeech 95-A55 · Springfield, ILJul 23, 1968 · N511JL · Substantial damage NTSB CHI69F0183Accident · No injuriesClosedCessna 150 · Rockford, ILJul 22, 1968 · N4560U · Destroyed NTSB CHI69D0162Accident · No injuriesClosedCessna 172 · Rockford, ILJul 20, 1968 · N8199L · Substantial damage NTSB CHI69A0008Accident · 1 fatalClosedPiper J3L · Sullivan, ILJul 20, 1968 · N32743 · Substantial damage NTSB CHI69D0137Accident · No injuriesClosedCessna 170B · Rochelle, ILJul 18, 1968 · N6095V · Substantial damage NTSB CHI69D0111Accident · No injuriesClosedPiper J3C-65 · Crystal Lake, ILJul 18, 1968 · N5740N · Substantial damage NTSB CHI69F0103Accident · Minor injuriesClosedBeech A23 · Peoria, ILJul 13, 1968 · N2381J · Substantial damage NTSB CHI69F0132Accident · No injuriesClosedCessna 150 · Mattoon, ILJul 12, 1968 · N6519S · Substantial damage NTSB CHI69F0099Accident · No injuriesClosedCessna 150G · Greenwood, ILJul 10, 1968 · N3051S · Substantial damage NTSB CHI69D0095Accident · No injuriesClosedPiper PA-28 · Utica, ILJul 10, 1968 · N9792W · Substantial damage NTSB CHI69F0085Accident · No injuriesClosedPiper PA-30 · Clinton, ILJul 8, 1968 · N7656Y · Substantial damage NTSB CHI69F0079Accident · No injuriesClosedCessna 150 · Wheeling, ILJul 7, 1968 · N6352S · Substantial damage NTSB CHI69F0078Accident · Minor injuriesClosedCessna 172I · Lombard, ILJul 6, 1968 · N8358L · Destroyed NTSB CHI69D0100Accident · No injuriesClosedPiper PA-28 · Wheeling, ILJul 5, 1968 · N4451J · Substantial damage NTSB CHI69A0001Accident · 1 fatalClosedMorrisey 2150A · Lawrenceville, ILJul 2, 1968 · N5136V · Destroyed NTSB CHI69D0094Accident · No injuriesClosedCessna 177 · Utica, ILJun 30, 1968 · N2254Y · Substantial damage NTSB CHI69D0071Accident · No injuriesClosedPiper PA-22 · Richton Park, ILJun 30, 1968 · N3827P · Substantial damage NTSB CHI69D0059Accident · No injuriesClosedPiper PA-24 · Joliet, ILJun 24, 1968 · N7425P · Substantial damage NTSB CHI68A0109Accident · 1 fatalClosedBeech 65-90 · Chicago, ILJun 24, 1968 · N895K · Minor damage NTSB CHI69F0032Accident · No injuriesClosedPiper PA-28 · Rantoul, ILJun 20, 1968 · N5101G · Substantial damage NTSB CHI69F0043Accident · No injuriesClosedCessna 320E · Wheeling, ILJun 12, 1968 · N600SM · Substantial damage NTSB CHI69F0022Accident · No injuriesClosedPiper PA-24 · Savanna, ILJun 7, 1968 · N8125P · Substantial damage NTSB CHI69F0019Accident · No injuriesClosedCessna 172 · Paris, ILJun 4, 1968 · N8392X · Substantial damage NTSB CHI68F0016Accident · No injuriesClosedHughes 269A · Richmond, ILJun 4, 1968 · N8873F · Substantial damage NTSB CHI69D0076Accident · No injuriesClosedGlobe GC-1B · Benton, ILJun 3, 1968 · N78181 · Substantial damage NTSB CHI68F0785Accident · No injuriesClosedBeech F35 · Kankakee, ILJun 2, 1968 · N800D · Substantial damage NTSB CHI68D0783Accident · No injuriesClosedBeech S35 · Chicago, ILJun 2, 1968 · N5825K · Substantial damage NTSB CHI69D0089Accident · Serious injuriesClosedHoward DGA-15 · Pekin, ILMay 30, 1968 · N5707N · Minor damage NTSB CHI69D0053Accident · No injuriesClosedCessna 310 · Toledo, ILMay 25, 1968 · N599DJ · Substantial damage NTSB CHI69F0069Accident · Serious injuriesClosedSchweizer SGS-1 · Lawrenceville, ILMay 19, 1968 · N8652R · Substantial damage