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 CHI67D0581Accident · No injuriesClosedCessna 320E · Wheeling, ILJan 11, 1967 · N600SM · Substantial damage NTSB CHI67D0442Accident · No injuriesClosedCessna 172 · St.Charles, ILJan 11, 1967 · N36111 · Substantial damage NTSB CHI67F0444Accident · No injuriesClosedErcoupe 415-C · Chicago, ILJan 10, 1967 · N99724 · Substantial damage NTSB CHI67D0452Accident · Minor injuriesClosedPiper PA-22 · Elgin, ILJan 8, 1967 · N5788Z · Substantial damage NTSB CHI67F0449Accident · No injuriesClosedCessna 310 · Springfield, ILJan 5, 1967 · N8912Z · Substantial damage NTSB CHI67F0428Accident · No injuriesClosedPiper PA-28 · Hinsdale, ILJan 4, 1967 · N6870W · Substantial damage NTSB CHI67D0440Accident · No injuriesClosedPiper PA-22 · Lombard, ILJan 4, 1967 · N5822Z · Substantial damage NTSB CHI68D0478Accident · No injuriesClosedPiper PA-28 · Peoria, ILJan 1, 1967 · N150SU · Substantial damage NTSB CHI67D0508Accident · No injuriesClosedCessna 150 · Lombard, ILDec 26, 1966 · N8002F · Substantial damage NTSB CHI67F0422Accident · No injuriesClosedBeech 35 · Roselle, ILDec 25, 1966 · N3745N · Substantial damage NTSB CHI67F0431Accident · No injuriesClosedCessna 150D · Deerfield, ILDec 22, 1966 · N4429U · Substantial damage NTSB CHI67A0077Accident · Serious injuriesClosedPiper PA-30B · Bloomington, ILDec 16, 1966 · N8162Y · Substantial damage NTSB CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILDec 16, 1966 · N3725H · Destroyed NTSB CHI67A0075Accident · No injuriesClosedPiper PA-24 · Quincy, ILDec 16, 1966 · N5578P · Substantial damage NTSB CHI67F0402Accident · No injuriesClosedCessna 175 · St.Charles, ILDec 12, 1966 · N7005M · Substantial damage NTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILDec 6, 1966 · N6088R · Substantial damage NTSB CHI67A0071Accident · No injuriesClosedViscount V-700 · Chicago, ILDec 4, 1966 · N7450 · Substantial damage NTSB CHI67F0426Accident · No injuriesClosedPiper PA-28 · Geneva, ILDec 3, 1966 · N8178W · Substantial damage NTSB CHI67F0372Accident · Serious injuriesClosedBeech G35 · Warrenville, ILNov 28, 1966 · N4422D · Substantial damage NTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNov 28, 1966 · N6663A · Substantial damage NTSB CHI67D0418Accident · Minor injuriesClosedCessna 172 · Kasbeer, ILNov 26, 1966 · N3588S · Substantial damage NTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNov 26, 1966 · N9762R · Destroyed NTSB CHI67F0374Accident · Serious injuriesClosedCessna 180 · Half Day, ILNov 21, 1966 · N9300C · Destroyed NTSB CHI67F0359Accident · No injuriesClosedPiper PA-22 · Seymour, ILNov 20, 1966 · N4858Z · Substantial damage NTSB CHI67A0065Accident · Minor injuriesClosedLockheed L-18 · Chicago, ILNov 17, 1966 · N339 · Substantial damage NTSB CHI67D0363Accident · No injuriesClosedCessna 210 · Wheeling, ILNov 16, 1966 · N3836Y · Substantial damage NTSB CHI67A0063Accident · Minor injuriesClosedFairchild F-27 · Chicago, ILNov 14, 1966 · N4300F · Substantial damage NTSB CHI67F0328Accident · No injuriesClosedBeech 23 · Lacon, ILNov 13, 1966 · N2348J · Substantial damage NTSB CHI67D0488Accident · No injuriesClosedCessna 170B · Sandwich, ILNov 5, 1966 · N2272D · Substantial damage NTSB CHI67A0061Accident · No injuriesClosedN.American NA-265 · Chicago, ILNov 5, 1966 · N360J · Substantial damage NTSB CHI67F0376Accident · No injuriesClosedCessna 210 · Northbrook, ILOct 30, 1966 · N6558X · Substantial damage NTSB CHI67F0353Accident · Minor injuriesClosedCessna 120 · Oswego, ILOct 29, 1966 · N2607N · Substantial damage NTSB CHI67D0370Accident · No injuriesClosedPiper PA-23 · Sparta, ILOct 28, 1966 · N903AR · Substantial damage NTSB CHI67F0030Accident · No injuriesClosedPiper PA30 · Decatur, ILOct 24, 1966 · N7160Y · Substantial damage NTSB CHI67D0636Accident · No injuriesClosedCessna 172 · Pittsfield, ILOct 20, 1966 · N3891L · Substantial damage NTSB CHI67F0377Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 19, 1966 · N9056J · Substantial damage NTSB CHI67D0362Accident · No injuriesClosedCessna 120 · Wheeling, ILOct 16, 1966 · N1772V · Substantial damage NTSB CHI67F0269Accident · No injuriesClosedPiper PA-28 · Sycamore, ILOct 11, 1966 · N5103W · Substantial damage NTSB CHI67F0310Accident · No injuriesClosedBeech D50A · Waukegan, ILOct 10, 1966 · N660M · Substantial damage NTSB CHI67F0258Accident · No injuriesClosedTaylorcraft BC12-D · Lombard, ILOct 8, 1966 · N43826 · Substantial damage NTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILOct 8, 1966 · N3728J · Substantial damage NTSB CHI67D0270Accident · No injuriesClosedPiper PA-24 · Northbrook, ILOct 8, 1966 · N7083P · Substantial damage NTSB CHI67A0048Accident · 1 fatalClosedChampion 7GCAA · Olney, ILOct 8, 1966 · N8347V · Destroyed NTSB CHI67F0331Accident · No injuriesClosedGlobe GC-1B · Wheeling, ILOct 5, 1966 · N80605 · 2 aircraft · Substantial damage NTSB CHI67F0282Accident · No injuriesClosedBellanca 14-19 · Belleville, ILOct 4, 1966 · N8506R · Substantial damage NTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILOct 2, 1966 · N3514J · 2 aircraft · Substantial damage NTSB CHI67D0646Accident · No injuriesClosedPiper PA-30 · Benton, ILSep 25, 1966 · N7124Y · Substantial damage NTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILSep 25, 1966 · N5194A · Destroyed NTSB CHI67D0371Accident · No injuriesClosedCessna 182 · Macomb, ILSep 22, 1966 · N2412Q · Substantial damage NTSB CHI67A0011Accident · 1 fatalClosedBeech F35 · Orland Park, ILSep 21, 1966 · N3825B · Destroyed