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 CHI68F0373Accident · No injuriesClosedPiper PA-28 · Salem, ILOct 26, 1967 · N8474W · Substantial damage NTSB CHI68A0038Accident · 2 fatalClosedCessna 182H · Collinsville, ILOct 24, 1967 · N1824X · Destroyed NTSB CHI68F0459Accident · No injuriesClosedPiper PA-28 · Canton, ILOct 23, 1967 · N9114W · Substantial damage NTSB CHI68F0400Accident · No injuriesClosedNavion B · Scott Afb, ILOct 22, 1967 · N5271K · Substantial damage NTSB CHI68F0396Accident · Serious injuriesClosedStinson 108 · Moweaqua, ILOct 22, 1967 · N40114 · Substantial damage NTSB CHI68A0037Accident · 1 fatalClosedBensen B8M · Lockport, ILOct 22, 1967 · N24082 · Destroyed NTSB CHI68D0418Accident · No injuriesClosedCessna 177 · Chicago, ILOct 19, 1967 · N2210Y · Substantial damage NTSB CHI68D0423Accident · No injuriesClosedPiper PA-22 · Rock Falls, ILOct 17, 1967 · N3074Z · Substantial damage NTSB CHI68F0370Accident · No injuriesClosedLuscombe 8A · Belleville, ILOct 15, 1967 · N1280B · Substantial damage NTSB CHI68A0036Accident · No injuriesClosedBrantly B2B · Cahokia, ILOct 15, 1967 · N1120K · Substantial damage NTSB CHI68D0390Accident · No injuriesClosedCessna 150 · Streator, ILOct 14, 1967 · N3093S · Substantial damage NTSB CHI68D0374Accident · No injuriesClosedCessna 172 · Beecher, ILOct 14, 1967 · N8795B · Substantial damage NTSB CHI68F0388Accident · No injuriesClosedBeech V35 · Kankakee, ILOct 10, 1967 · N2056W · Substantial damage NTSB CHI68D0449Accident · No injuriesClosedBeech M35 · Chicago, ILOct 8, 1967 · N934 · Substantial damage NTSB CHI68D0343Accident · No injuriesClosedPiper PA-12 · Vandalia, ILOct 7, 1967 · N4396M · Substantial damage NTSB CHI68F0419Accident · No injuriesClosedBeech 35 · New Lenox, ILOct 4, 1967 · N8479A · Substantial damage NTSB CHI68D0358Accident · Minor injuriesClosedStinson V77 · Pekin, ILOct 4, 1967 · N64435 · Substantial damage NTSB CHI68D0347Accident · No injuriesClosedMooney 20E · Chicago, ILSep 30, 1967 · N5506Q · Substantial damage NTSB CHI68F0342Accident · Minor injuriesClosedLuscombe 8E · Pleasant Hill, ILSep 26, 1967 · N2993K · Substantial damage NTSB CHI68A0030Accident · 2 fatalClosedCessna 310H · Coal Valley, ILSep 26, 1967 · N1148Q · Destroyed NTSB CHI68D0355Accident · No injuriesClosedBeech S35 · Springfield, ILSep 23, 1967 · N505V · Substantial damage NTSB CHI68F0369Accident · Minor injuriesClosedCessna 310H · Streator, ILSep 21, 1967 · N1096Q · Substantial damage NTSB CHI68F0367Accident · No injuriesClosedCessna 140 · Mt.Sterling, ILSep 21, 1967 · N89883 · Substantial damage NTSB CHI68F0325Accident · No injuriesClosedCessna 210 · Freeport, ILSep 18, 1967 · N7475E · Substantial damage NTSB CHI68D0387Accident · Minor injuriesClosedAeronca 7AC · Naperville, ILSep 17, 1967 · N85356 · Substantial damage NTSB CHI68D0313Accident · No injuriesClosedCessna 140 · Dekalb, ILSep 16, 1967 · N2905N · Substantial damage NTSB CHI68F0421Accident · No injuriesClosedPiper PA-32 · Monticello, ILSep 10, 1967 · N3458W · Substantial damage NTSB CHI68D0427Accident · No injuriesClosedMooney M20A · Lombard, ILSep 9, 1967 · N8179E · Substantial damage NTSB CHI68F0319Accident · No injuriesClosedCessna 310C · Waukegan, ILSep 8, 1967 · N460CA · Substantial damage NTSB CHI68D0286Accident · No injuriesClosedCessna 170B · Ipava, ILSep 8, 1967 · N2899C · Substantial damage NTSB CHI68A0025Accident · 2 fatalClosedErco 415C · Hillsdale, ILSep 7, 1967 · N99034 · Substantial damage NTSB CHI68F0322Accident · No injuriesClosedLear Jet 23 · Wheeling, ILSep 6, 1967 · N1966W · Substantial damage NTSB CHI68F0239Accident · No injuriesClosedCessna 120 · Pekin, ILSep 6, 1967 · N72119 · Substantial damage NTSB CHI68F0283Accident · No injuriesClosedPiper PA-24 · W Chicago, ILSep 5, 1967 · N8900P · Substantial damage NTSB CHI68F0368Accident · No injuriesClosedCessna 182 · Roodhouse, ILSep 4, 1967 · N3707D · Substantial damage NTSB CHI68D0357Accident · No injuriesClosedPiper PA-22 · Lombard, ILSep 4, 1967 · N5822Z · Substantial damage NTSB CHI68D0321Accident · No injuriesClosedCessna 150F · Rockford, ILSep 2, 1967 · N8136S · Substantial damage NTSB CHI68F0245Accident · No injuriesClosedPiper PA-28 · Monee, ILAug 28, 1967 · N5788W · Substantial damage NTSB CHI68D0267Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 28, 1967 · N8602G · Substantial damage NTSB CHI68F0247Accident · No injuriesClosedBeech 23 · Naperville, ILAug 26, 1967 · N2347J · Substantial damage NTSB CHI68D0346Accident · No injuriesClosedErco 415-C · Elgin, ILAug 26, 1967 · N2764H · Substantial damage NTSB CHI68F0282Accident · Minor injuriesClosedStinson 108-1 · Hidalgo, ILAug 25, 1967 · N8290K · Substantial damage NTSB CHI68F0284Accident · No injuriesClosedCessna 150 · Warren, ILAug 23, 1967 · N2985J · Substantial damage NTSB CHI68D0246Accident · No injuriesClosedBeech J35 · Chicago, ILAug 23, 1967 · N3028C · Substantial damage NTSB CHI68F0333Accident · Minor injuriesClosedPiper PA-22 · Columbia, ILAug 20, 1967 · N3501Z · Substantial damage NTSB CHI68D0366Accident · No injuriesClosedPiper PA-24 · Chicago, ILAug 20, 1967 · N8798P · Substantial damage NTSB CHI68F0318Accident · No injuriesClosedCessna 172 · Pekin, ILAug 18, 1967 · N8754B · Substantial damage NTSB CHI68F0266Accident · No injuriesClosedDehaviland DH 104 · Wheeling, ILAug 18, 1967 · N999NJ · Substantial damage NTSB CHI68F0205Accident · No injuriesClosedPiper PA-28 · Bloomington, ILAug 18, 1967 · N6679W · Substantial damage NTSB CHI68D0228Accident · No injuriesClosedCessna 150 · Greenwood, ILAug 16, 1967 · N6933F · Substantial damage