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 CHI74FEE33Accident · No injuriesClosedCessna 210H · Rockford, ILNov 15, 1973 · N5991F · Substantial damage NTSB CHI74AC041Accident · No injuriesClosedDassault Falcon · Galesburg, ILNov 9, 1973 · N910L · Substantial damage NTSB CHI74FEV26Accident · No injuriesClosedAeronca 7EC · Monticello, ILNov 5, 1973 · N85547 · Substantial damage NTSB CHI74AEV27Accident · Serious injuriesClosedCessna 140 · Hull, ILNov 5, 1973 · N72391 · Substantial damage NTSB CHI74AC039Accident · No injuriesClosedBeech E18E · Chicago, ILNov 1, 1973 · N251K · Substantial damage NTSB CHI74DEE32Accident · No injuriesClosedPiper PA-28 · Rockford, ILOct 27, 1973 · N9301J · Substantial damage NTSB CHI74DEE31Accident · Minor injuriesClosedCessna 182N · Polo, ILOct 27, 1973 · N9060G · Substantial damage NTSB CHI74DEV25Accident · No injuriesClosedPiper PA-28 · Rowe, ILOct 24, 1973 · N6762W · Substantial damage NTSB CHI74FEV24Accident · No injuriesClosedCessna 182H · Rushville, ILOct 21, 1973 · N8516S · Substantial damage NTSB CHI74FEE29Accident · No injuriesClosedCessna 182A · Marseilles, ILOct 21, 1973 · N5983B · Substantial damage NTSB CHI74AEE30Accident · No injuriesClosedAero Comdr 720 · Rockton, ILOct 21, 1973 · N688R · Substantial damage NTSB CHI74FEE28Accident · No injuriesClosedCessna 182 · Polo, ILOct 19, 1973 · N2093X · Destroyed NTSB CHI74FEE26Accident · 1 fatalClosedCessna 320 · Northbrook, ILOct 14, 1973 · N861W · Destroyed NTSB CHI74FEE27Accident · No injuriesClosedCessna 172K · Plainfield, ILOct 13, 1973 · N7341G · Substantial damage NTSB CHI74AC031Accident · 2 fatalClosedBellanca 7GCBC · Morris, ILOct 6, 1973 · N36034 · Destroyed NTSB CHI74FEV22Accident · No injuriesClosedMitsubishi MU-2 · Springfield, ILOct 5, 1973 · N887Q · Substantial damage NTSB CHI74FEE25Accident · No injuriesClosedPiper PA-28 · Eglin, ILOct 5, 1973 · N55707 · Substantial damage NTSB CHI74AC029Accident · 1 fatalClosedAerostar 601 · Chicago, ILOct 3, 1973 · N8MW · Destroyed NTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILSep 30, 1973 · N8225N · Substantial damage NTSB CHI74FEE22Accident · No injuriesClosedCessna 310K · Wheeling, ILSep 24, 1973 · N7012L · Substantial damage NTSB CHI74FEE23Accident · No injuriesClosedCessna 310J · West Chicago, ILSep 22, 1973 · N3187L · Substantial damage NTSB CHI74FEE20Accident · Serious injuriesClosedBeech 35 · Streator, ILSep 18, 1973 · N3325V · Destroyed NTSB CHI74FEE19Accident · No injuriesClosedCessna 320E · Downers Grove, ILSep 16, 1973 · N2JF · Substantial damage NTSB CHI74FEE21Accident · No injuriesClosedLuscombe 8E · Grayslake, ILSep 15, 1973 · N2600K · Substantial damage NTSB CHI74AC023Accident · 3 fatalClosedBeech B23 · Carbondale, ILSep 15, 1973 · N6069N · Destroyed NTSB CHI74FEV21Accident · No injuriesClosedNavion A · Monmouth, ILSep 14, 1973 · N1105M · Substantial damage NTSB NYC74AN022Accident · 1 fatalClosedCessna 172H · Wheeling, ILSep 13, 1973 · N2665L · 2 aircraft · Minor damage NTSB CHI74FCA01Accident · Minor injuriesClosedCessna T210L · Cahokia, ILSep 13, 1973 · N30607 · Substantial damage NTSB CHI74FEE18Accident · Minor injuriesClosedPiper PA-22 · Glenwood, ILSep 10, 1973 · N5725D · Substantial damage NTSB CHI74FEV20Accident · No injuriesClosedCessna 170B · St Joseph, ILSep 8, 1973 · N2758C · Substantial damage NTSB CHI74DEV19Accident · Minor injuriesClosedPiper PA-28 · Bloomington, ILSep 7, 1973 · N2341T · Substantial damage NTSB CHI74FEV18Accident · No injuriesClosedBeech A35 · Macomb, ILSep 3, 1973 · N188Q · Substantial damage NTSB CHI74FEV17Accident · Minor injuriesClosedPiper PA-22 · Atwood, ILSep 2, 1973 · N2451A · Substantial damage NTSB CHI74FEV16Accident · Serious injuriesClosedPiper PA-28 · Mt Sterling, ILSep 2, 1973 · N98013 · Substantial damage NTSB CHI74FEE16Accident · No injuriesClosedLuscombe 8A · Schaumburg, ILAug 26, 1973 · N71446 · Substantial damage NTSB CHI74FEV15Accident · No injuriesClosedCessna 177 · Pittsfield, ILAug 25, 1973 · N3485T · Substantial damage NTSB CHI74FEE15Accident · No injuriesClosedCessna 170A · Streator, ILAug 20, 1973 · N1390D · Substantial damage NTSB CHI74FEE11Accident · No injuriesClosedCessna 150 · Wheeling, ILAug 20, 1973 · N3135J · Substantial damage NTSB UNK73X0121Accident · 1 fatalClosedTaylor Titch · Salem, ILAug 19, 1973 · N1SK · Destroyed NTSB CHI74FEV14Accident · Minor injuriesClosedBoeing A75N1 · Martinsville, ILAug 18, 1973 · N61860 · Substantial damage NTSB CHI74FEE14Accident · Minor injuriesClosedPiper PA-22 · Naperville, ILAug 18, 1973 · N2401A · Substantial damage NTSB CHI74FEE12Accident · No injuriesClosedPiper PA-28 · Elburn, ILAug 12, 1973 · N8863N · Substantial damage NTSB CHI74FEE09Accident · No injuriesClosedStinson L-5 · Rockford, ILAug 12, 1973 · N65414 · Substantial damage NTSB CHI74FEV11Accident · Serious injuriesClosedGrumman G-164A · Towanda, ILAug 11, 1973 · N5331 · Destroyed NTSB CHI74FEE13Accident · No injuriesClosedLuscombe 11A · Wheeling, ILAug 10, 1973 · N1629B · Substantial damage NTSB CHI74DEE10Accident · No injuriesClosedJugman Bucker · S.Naperville, ILAug 10, 1973 · N619N · Substantial damage NTSB CHI74FEV12Accident · No injuriesClosedPiper PA-25 · Washington, ILAug 8, 1973 · N7753Z · Substantial damage NTSB CHI74FEE08Accident · Minor injuriesClosedBeech 35-C33 · Harvard, ILAug 8, 1973 · N568UC · Substantial damage NTSB CHI74FEV10Accident · No injuriesClosedBrantly B-2B · Gibson City, ILAug 6, 1973 · N2253U · Substantial damage NTSB CHI74AC012Accident · 1 fatalClosedCessna 182J · Chicago, ILAug 6, 1973 · N3147F · Destroyed