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 CHI68D0604Accident · No injuriesClosedCessna 172 · Grayslake, ILFeb 15, 1968 · N8001B · Substantial damage NTSB CHI68F0573Accident · Minor injuriesClosedCessna 150G · Midlothian, ILFeb 3, 1968 · N3200J · Substantial damage NTSB CHI68F0601Accident · No injuriesClosedPiper PA-23 · Northbrook, ILFeb 2, 1968 · N4342P · Substantial damage NTSB CHI68F0556Accident · No injuriesClosedCessna 172H · Springfield, ILFeb 2, 1968 · N8199L · Substantial damage NTSB CHI68I0066Incident · No injuriesClosedConvair 880 · Chicago, ILJan 31, 1968 · N810TW · Minor damage NTSB CHI68F0595Accident · No injuriesClosedTemco D-16 · Sycamore, ILJan 30, 1968 · N70N · Substantial damage NTSB CHI68F0567Accident · Serious injuriesClosedCessna 172 · Princeton, ILJan 30, 1968 · N1121F · Destroyed NTSB CHI68F0563Accident · No injuriesClosedPiper PA-30 · Bloomington, ILJan 24, 1968 · N7626Y · Substantial damage NTSB CHI68F0587Accident · No injuriesClosedPiper PA-28 · Bloomington, ILJan 23, 1968 · N6928W · Substantial damage NTSB CHI68F0564Accident · No injuriesClosedBeech B95 · Urbana, ILJan 21, 1968 · N312H · Substantial damage NTSB CHI68D0559Accident · No injuriesClosedCessna 150 · Lake Zurich, ILJan 21, 1968 · N2099Z · Substantial damage NTSB CHI68D0557Accident · No injuriesClosedMooney M20C · Kankakee, ILJan 21, 1968 · N3411X · Substantial damage NTSB CHI68D0549Accident · No injuriesClosedPiper PA-22 · Salem, ILJan 20, 1968 · N5415Z · Substantial damage NTSB CHI68D0540Accident · No injuriesClosedBeech A35-33 · Morton, ILJan 16, 1968 · N471T · Substantial damage NTSB CHI68D0547Accident · No injuriesClosedPiper PA-11 · Earlville, ILJan 15, 1968 · N5006H · Substantial damage NTSB CHI68F0541Accident · Serious injuriesClosedPiper PA-28 · Pekin, ILJan 12, 1968 · N7096R · Substantial damage NTSB CHI68I0060Incident · No injuriesClosedDehavilland DH104 · Chicago, ILJan 9, 1968 · N420D · Substantial damage NTSB CHI68F0507Accident · No injuriesClosedPiper PA-24 · Tremont, ILJan 5, 1968 · N6877P · Substantial damage NTSB CHI68D0535Accident · No injuriesClosedCessna 172 · Chicago, ILJan 3, 1968 · N5443R · Substantial damage NTSB CHI68D0536Accident · No injuriesClosedPiper PA-28 · Waukegan, ILDec 31, 1967 · N6195W · Substantial damage NTSB CHI68A0058Accident · 2 fatalClosedNavion F · Murphysboro, ILDec 29, 1967 · N91461 · Destroyed NTSB CHI68F0553Accident · No injuriesClosedPiper PA-28 · Collinsville, ILDec 26, 1967 · N4538R · Substantial damage NTSB CHI68D0522Accident · No injuriesClosedCessna 150G · Carbondale, ILDec 26, 1967 · N3191J · Substantial damage NTSB CHI68D0525Accident · Minor injuriesClosedCessna 182 · Roscoe, ILDec 25, 1967 · N2482G · Substantial damage NTSB CHI68F0511Accident · No injuriesClosedCessna 150 · Lockport, ILDec 24, 1967 · N4046U · Substantial damage NTSB CHI68F0512Accident · Serious injuriesClosedBeech D18S · Beloit, ILDec 22, 1967 · N120R · Substantial damage NTSB CHI68A0055Accident · No injuriesClosedBeech C45H · Chicago, ILDec 21, 1967 · N2122 · Substantial damage NTSB CHI68F0551Accident · No injuriesClosedBeech 95-A55 · Lebanon, ILDec 20, 1967 · N511JL · Substantial damage NTSB CHI68D0539Accident · No injuriesClosedPiper PA-28 · Roselle, ILDec 19, 1967 · N9105W · Substantial damage NTSB CHI68F0513Accident · Minor injuriesClosedPorterfield LP-65 · Taylor Ridge, ILDec 17, 1967 · N37853 · Substantial damage NTSB CHI68F0501Accident · Minor injuriesClosedBeech K35 · Wheeling, ILDec 16, 1967 · N801R · Substantial damage NTSB CHI68F0490Accident · No injuriesClosedCessna 150 · Desoto, ILDec 8, 1967 · N3545L · Substantial damage NTSB CHI68D0489Accident · No injuriesClosedChampion 7FC · Savoy, ILDec 7, 1967 · N8570E · Substantial damage NTSB CHI68F0458Accident · No injuriesClosedBeech P35 · Marion, ILDec 6, 1967 · N9651Y · Substantial damage NTSB CHI68F0469Accident · No injuriesClosedPiper PA-23 · Cottage Hill, ILDec 5, 1967 · N148AF · Substantial damage NTSB CHI68F0502Accident · 1 fatalClosedBeech J35 · Chicago, ILDec 4, 1967 · N8240D · Destroyed NTSB CHI68F0450Accident · Minor injuriesClosedBeech H35 · Lombard, ILNov 28, 1967 · N5557D · Destroyed NTSB CHI68F0437Accident · No injuriesClosedBeech A45 · Okawville, ILNov 19, 1967 · N874Z · Substantial damage NTSB CHI68D0445Accident · No injuriesClosedPiper PA-28 · Roselle, ILNov 19, 1967 · N6398R · Substantial damage NTSB CHI68D0470Accident · No injuriesClosedMaule M-4 · Chicago, ILNov 18, 1967 · N4710T · Substantial damage NTSB CHI68D0443Accident · No injuriesClosedMooney M20A · Wheeling, ILNov 17, 1967 · N8390E · Substantial damage NTSB CHI68D0439Accident · Minor injuriesClosedChampion 7FC · Monticello, ILNov 13, 1967 · N7696E · Substantial damage NTSB CHI68F0476Accident · Minor injuriesClosedBeech V35 · Springfield, ILNov 12, 1967 · N9486S · Substantial damage NTSB CHI68D0440Accident · No injuriesClosedPiper PA-28 · Peoria, ILNov 9, 1967 · N9563J · Substantial damage NTSB CHI68D0434Accident · No injuriesClosedCessna 310 · Sugar Grove, ILNov 9, 1967 · N8181M · Substantial damage NTSB CHI68F0435Accident · Minor injuriesClosedCessna 195 · Sandwich, ILNov 8, 1967 · N3452V · Destroyed NTSB CHI68D0436Accident · No injuriesClosedMooney M20E · Banner, ILNov 6, 1967 · N3228F · Substantial damage NTSB CHI68F0451Accident · No injuriesClosedCessna 310B · Kankakee, ILNov 5, 1967 · N5287A · Substantial damage NTSB CHI68F0509Accident · No injuriesClosedCessna 411A · Cairo, ILNov 4, 1967 · N4934T · Substantial damage NTSB CHI68F0398Accident · Minor injuriesClosedCessna 172 · Columbia, ILNov 4, 1967 · N8695U · Substantial damage