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 CHI69D0674Accident · No injuriesClosedCessna 150 · Ringwood, ILMay 22, 1969 · N6933F · Substantial damage NTSB CHI70F0018Accident · No injuriesClosedStinson 108-2 · Peoria, ILMay 21, 1969 · N130C · Substantial damage NTSB CHI69A0096Accident · 1 fatalClosedCessna 150G · Ofallon, ILMay 20, 1969 · N3655J · Destroyed NTSB CHI69D0640Accident · No injuriesClosedPiper PA-28 · Princeton, ILMay 14, 1969 · N6383R · Substantial damage NTSB CHI69I0094Incident · No injuriesClosedBeech 65 · Chicago, ILMay 12, 1969 · N140 · Minor damage NTSB CHI70D0036Incident · Minor injuriesClosedCessna 205 · Roscoe, ILMay 11, 1969 · N2837Z · Minor damage NTSB CHI69D0673Accident · Minor injuriesClosedCessna 150 · Lockport, ILMay 11, 1969 · N23502 · Substantial damage NTSB CHI70D0003Accident · No injuriesClosedCessna 172 · Collinsville, ILMay 10, 1969 · N35722 · Substantial damage NTSB CHI69A0092Accident · No injuriesClosedDouglas DC-8 · Chicago, ILMay 8, 1969 · N1303L · 2 aircraft · Substantial damage NTSB CHI69D0661Accident · No injuriesClosedPiper PA-23 · Lansing, ILMay 5, 1969 · N6575Y · Substantial damage NTSB CHI69F0612Accident · Serious injuriesClosedStits SA-3B · Wheeling, ILMay 4, 1969 · N174D · Substantial damage NTSB CHI69F0652Accident · Minor injuriesClosedSteffens A69 · Forrest, ILMay 3, 1969 · N7108 · Destroyed NTSB CHI69D0649Accident · No injuriesClosedCessna 172 · East St.Louis, ILMay 3, 1969 · N4450L · Substantial damage NTSB CHI69D0603Accident · Minor injuriesClosedBensen B-8M · Antioch, ILMay 3, 1969 · N11993 · Substantial damage NTSB CHI69D0628Accident · No injuriesClosedStinson 108-2 · Lombard, ILApr 30, 1969 · N9837K · Substantial damage NTSB CHI70F0017Accident · No injuriesClosedPiper PA-25 · Harvel, ILApr 29, 1969 · N7472Z · Destroyed NTSB CHI69D0639Accident · No injuriesClosedPiper PA-22 · Wheeling, ILApr 29, 1969 · N5714Z · Substantial damage NTSB CHI69F0616Accident · No injuriesClosedCessna 177A · West Chicago, ILApr 27, 1969 · N30389 · Substantial damage NTSB CHI69A0087Accident · No injuriesClosedBeech 99 · Danville, ILApr 24, 1969 · N315VA · Substantial damage NTSB CHI69F0662Accident · Minor injuriesClosedMooney M20C · Northbrook, ILApr 20, 1969 · N6836N · Substantial damage NTSB CHI69F0651Accident · Minor injuriesClosedCessna 175 · Richton Park, ILApr 20, 1969 · N6803E · Destroyed NTSB CHI69D0564Accident · No injuriesClosedCessna 310D · Rockford, ILApr 16, 1969 · N6893T · Substantial damage NTSB CHI70F0151Accident · No injuriesClosedCessna 421A · Hoopeston, ILApr 14, 1969 · N2970Q · Substantial damage NTSB CHI69D0635Accident · No injuriesClosedAlon A-2 · Orland Park, ILApr 7, 1969 · N5491E · Substantial damage NTSB CHI69F0575Accident · No injuriesClosedMooney M20C · Joliet, ILApr 6, 1969 · N9281M · Substantial damage NTSB CHI69F0563Accident · No injuriesClosedCessna 150 · Rockford, ILApr 5, 1969 · N50850 · Substantial damage NTSB CHI69D0572Accident · No injuriesClosedPiper PA-28 · Wheeling, ILApr 5, 1969 · N1862J · Substantial damage NTSB CHI69A0084Accident · 4 fatalClosedPiper PA-24 · Aledo, ILMar 30, 1969 · N6346P · Destroyed NTSB CHI69A0083Accident · No injuriesClosedCessna 402 · Chicago, ILMar 25, 1969 · N3207Q · Substantial damage NTSB CHI69F0629Accident · Serious injuriesClosedPiper PA-28 · Chrisman, ILMar 23, 1969 · N6559J · Substantial damage NTSB CHI69D0608Accident · No injuriesClosedPiper PA-22 · Midlothian, ILMar 23, 1969 · N3413Z · Substantial damage NTSB CHI69F0548Accident · No injuriesClosedCessna 150 · Collinsville, ILMar 18, 1969 · N8391G · Substantial damage NTSB CHI69F0549Accident · Serious injuriesClosedPiper PA-24 · Joliet, ILMar 17, 1969 · N6024P · Destroyed NTSB CHI69D0574Accident · No injuriesClosedPiper PA-23 · Elgin, ILMar 17, 1969 · N6633Y · Substantial damage NTSB CHI69F0536Accident · No injuriesClosedBeech C35 · Rockford, ILMar 16, 1969 · N5856C · Substantial damage NTSB CHI69F0545Accident · No injuriesClosedCessna 150F · Danville, ILMar 15, 1969 · N8346G · Substantial damage NTSB CHI69D0579Accident · No injuriesClosedCessna 150J · Carmi, ILMar 15, 1969 · N50344 · Substantial damage NTSB CHI69D0544Accident · No injuriesClosedBeech A23-19 · Waukegan, ILMar 15, 1969 · N4771J · Substantial damage NTSB CHI69A0079Accident · No injuriesClosedBeech C-45H · Peoria, ILMar 10, 1969 · N9805Z · Substantial damage NTSB CHI69F0516Accident · No injuriesClosedBeech A23-19 · Joliet, ILMar 7, 1969 · N5662S · Substantial damage NTSB CHI69D0532Accident · No injuriesClosedBeech C35 · Waukegan, ILMar 5, 1969 · N1852D · Substantial damage NTSB CHI69F0507Accident · No injuriesClosedCessna 150 · West Chicago, ILMar 4, 1969 · N8982S · Substantial damage NTSB CHI69F0521Accident · Serious injuriesClosedBensen B-8M · Lacon, ILFeb 28, 1969 · N1173 · Substantial damage NTSB CHI69D0504Accident · No injuriesClosedCessna 170B · Sterling, ILFeb 12, 1969 · N1637D · Substantial damage NTSB CHI69D0490Accident · No injuriesClosedPiper PA-28 · Northbrook, ILFeb 12, 1969 · N1635J · Substantial damage NTSB CHI69F0515Accident · Minor injuriesClosedAlon A-2 · Hinsdale, ILFeb 11, 1969 · N5665F · Substantial damage NTSB CHI69D0663Accident · No injuriesClosedPiper PA-28 · Casey, ILFeb 10, 1969 · N4602J · Substantial damage NTSB CHI70F0196Accident · Serious injuriesClosedCessna 337 · Monmouth, ILFeb 7, 1969 · N2154X · Destroyed NTSB CHI69F0580Accident · Serious injuriesClosedBeech G35 · Peoria, ILFeb 5, 1969 · N4447D · Destroyed NTSB CHI69F0453Accident · No injuriesClosedCessna U206 · Wilow Springs, ILFeb 3, 1969 · N3460L · Substantial damage