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 CHI69F0500Accident · No injuriesClosedCessna 210J · Midlothian, ILFeb 2, 1969 · N6176F · Substantial damage NTSB CHI69D0523Accident · No injuriesClosedCessna 172 · Lisle, ILFeb 2, 1969 · N170AT · Substantial damage NTSB CHI70F0038Accident · No injuriesClosedCessna 150G · Penfield, ILJan 31, 1969 · N3499J · Substantial damage NTSB CHI69F0450Accident · No injuriesClosedCessna 150H · Northbrook, ILJan 25, 1969 · N22046 · Substantial damage NTSB CHI69D0477Accident · No injuriesClosedBeech A23-19 · Waukegan, ILJan 25, 1969 · N4771J · Substantial damage NTSB CHI69D0522Accident · No injuriesClosedPiper PA-28 · Flora, ILJan 24, 1969 · N8854J · Substantial damage NTSB DCA69I0001Incident · No injuriesClosedFairchild FH-227 · Springfield, ILJan 22, 1969 · N4224 · Minor damage NTSB CHI69D0449Accident · No injuriesClosedCessna 150G · Wheeling, ILJan 19, 1969 · N2823S · Substantial damage NTSB CHI69D0440Accident · No injuriesClosedBeech 56TC · Rockford, ILJan 15, 1969 · N7008N · Substantial damage NTSB CHI69D0439Accident · No injuriesClosedPiper PA-30 · Northbrook, ILJan 15, 1969 · OYDSG · Substantial damage NTSB CHI69D0459Accident · No injuriesClosedCessna 337 · Northbrook, ILJan 13, 1969 · N2258X · Substantial damage NTSB CHI70D0019Accident · No injuriesClosedPiper PA-28 · Pinckneyville, ILJan 11, 1969 · N7703W · Substantial damage NTSB CHI69D0463Accident · No injuriesClosedPiper PA-28 · Streator, ILJan 11, 1969 · N9745J · Substantial damage NTSB CHI69D0441Accident · No injuriesClosedNavion A · Richton Park, ILJan 11, 1969 · N8801H · Substantial damage NTSB CHI69D0447Accident · No injuriesClosedCessna 150F · Mendota, ILJan 10, 1969 · N8751G · Substantial damage NTSB CHI69F0438Accident · No injuriesClosedCessna 411 · Wheeling, ILJan 8, 1969 · N3205R · Substantial damage NTSB CHI69D0451Accident · No injuriesClosedPiper PA-28 · Park Forest, ILJan 8, 1969 · N8062N · Substantial damage NTSB CHI69F0466Accident · Minor injuriesClosedLuscombe 8A · Port Byron, ILJan 5, 1969 · N77834 · Substantial damage NTSB CHI69D0415Accident · No injuriesClosedPiper J3C-65 · Woodstock, ILJan 4, 1969 · N98047 · Substantial damage NTSB CHI69F0506Accident · No injuriesClosedMooney M20C · Effingham, ILJan 2, 1969 · N6721N · Substantial damage NTSB DCA69A0010Accident · 27 fatalClosedConvair 580 · Chicago, ILDec 27, 1968 · N2045 · Destroyed NTSB CHI69D0456Accident · No injuriesClosedPiper PA-24 · Wheeling, ILDec 26, 1968 · N8702P · Substantial damage NTSB CHI69D0437Accident · No injuriesClosedCessna 150G · Streator, ILDec 24, 1968 · N6227S · Substantial damage NTSB CHI69D0413Accident · No injuriesClosedCessna 150 · Kankakee, ILDec 23, 1968 · N7749E · Substantial damage NTSB CHI69D0458Accident · No injuriesClosedBeech B-35 · Granite City, ILDec 18, 1968 · N3331V · Substantial damage NTSB CHI69D0436Accident · No injuriesClosedLuscombe 8A · Waukegan, ILDec 16, 1968 · N45630 · Substantial damage NTSB CHI69F0420Accident · No injuriesClosedBeech E35 · Roselle, ILDec 14, 1968 · N3259C · Substantial damage NTSB CHI69I0062Incident · No injuriesClosedBoeing 720 · Chicago, ILDec 13, 1968 · N7217U · Minor damage NTSB CHI69F0429Accident · No injuriesClosedBeech A65 · Chicago, ILDec 13, 1968 · N941V · Substantial damage NTSB CHI69A0061Accident · 1 fatalClosedPiper PA-23 · Chicago, ILDec 12, 1968 · N4878P · Destroyed NTSB CHI69D0505Accident · No injuriesClosedPiper PA-28 · Sheldon, ILDec 11, 1968 · N9353W · Substantial damage NTSB CHI69A0060Accident · No injuriesClosedBeech C-45G · Chicago, ILDec 11, 1968 · N7697C · Substantial damage NTSB CHI69A0058Accident · No injuriesClosedCessna 150E · Sandwich, ILDec 8, 1968 · N3984U · 2 aircraft · Substantial damage NTSB CHI69D0388Accident · No injuriesClosedCessna P206 · Ottawa, ILDec 6, 1968 · N2568X · Substantial damage NTSB CHI69D0407Accident · No injuriesClosedBeech C35 · Chicago, ILDec 3, 1968 · N740D · Substantial damage NTSB CHI69D0383Accident · No injuriesClosedBeech A23-19 · Oswego, ILDec 1, 1968 · N5662S · Substantial damage NTSB CHI69D0646Accident · No injuriesClosedMooney M-20 · Carthage, ILNov 28, 1968 · N852B · Substantial damage NTSB CHI69A0057Accident · Minor injuriesClosedDouglas A-26B · Chicago, ILNov 26, 1968 · N919P · Substantial damage NTSB CHI69A0056Accident · No injuriesClosedDouglas DC-3C · Chicago, ILNov 25, 1968 · N27 · Substantial damage NTSB CHI69F0390Accident · No injuriesClosedCessna 140A · Lincoln, ILNov 24, 1968 · N9454A · Substantial damage NTSB CHI69D0372Accident · No injuriesClosedPiper PA-24 · Roselle, ILNov 24, 1968 · N7668P · Substantial damage NTSB CHI69D0510Accident · No injuriesClosedCessna 150F · Buckley, ILNov 23, 1968 · N8179F · Substantial damage NTSB CHI69D0397Accident · No injuriesClosedBeech A23 · Chicago, ILNov 23, 1968 · N1406L · Substantial damage NTSB CHI69D0374Accident · No injuriesClosedCessna 310C · Wheeling, ILNov 23, 1968 · N1883H · Substantial damage NTSB CHI69F0373Accident · Serious injuriesClosedPiper PA-12 · Bloomington, ILNov 22, 1968 · N3925M · Destroyed NTSB CHI69F0403Accident · No injuriesClosedPiper PA-32 · Peoria, ILNov 21, 1968 · N3200W · Substantial damage NTSB CHI69D0402Accident · No injuriesClosedPiper PA-28 · Northbrook, ILNov 20, 1968 · N9963W · Substantial damage NTSB CHI69D0389Accident · No injuriesClosedBeech 95-C55 · Cairo, ILNov 20, 1968 · N5726V · Substantial damage NTSB CHI69D0485Accident · Serious injuriesClosedBeech 95-C55 · Hamilton, ILNov 17, 1968 · N3769Q · Substantial damage NTSB CHI69A0050Accident · 2 fatalClosedCessna 150 · Frankfort, ILNov 15, 1968 · N22532 · Destroyed