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 CHI68D0163Accident · No injuriesClosedMooney M20C · Ringwood, ILJun 23, 1967 · N7165U · Substantial damage NTSB CHI67A0137Accident · Serious injuriesClosedBell 47G · Joliet, ILJun 23, 1967 · N867Z · Destroyed NTSB CHI68F0166Accident · No injuriesClosedCessna 411 · Downers Grove, ILJun 21, 1967 · N4928T · Substantial damage NTSB CHI68D0225Accident · No injuriesClosedCessna 182 · Chicago, ILJun 21, 1967 · N3380F · Substantial damage NTSB CHI68D0162Accident · No injuriesClosedMooney M20 · Moline, ILJun 20, 1967 · N3411X · Substantial damage NTSB CHI68D0353Accident · No injuriesClosedPiper J3C-65 · Harvard, ILJun 18, 1967 · N88551 · Substantial damage NTSB CHI68D0130Accident · No injuriesClosedPiper PA-23 · Chicago, ILJun 15, 1967 · N4240P · Substantial damage NTSB CHI68D0083Accident · No injuriesClosedBeech 23 · Joliet, ILJun 15, 1967 · N2328J · Substantial damage NTSB CHI67A0133Accident · Serious injuriesClosedBeech A23 · West Chicago, ILJun 15, 1967 · N4721J · Substantial damage NTSB CHI68F0482Accident · No injuriesClosedPiper PA-25 · St.James, ILJun 12, 1967 · N6403Z · Substantial damage NTSB CHI68F0127Accident · Minor injuriesClosedCessna 172G · Polo, ILJun 11, 1967 · N3696L · Substantial damage NTSB CHI68D0379Accident · No injuriesClosedPiper PA-28 · Moline, ILJun 11, 1967 · N9257J · Substantial damage NTSB CHI68D0129Accident · Minor injuriesClosedTaylorcraft BC-12D · Dixon, ILJun 9, 1967 · N95746 · Destroyed NTSB CHI68D0056Accident · No injuriesClosedPiper PA-22 · Midlothian, ILJun 8, 1967 · N5473Z · Substantial damage NTSB CHI67I0129Incident · No injuriesClosedBoeing 727 · Chicago, ILJun 8, 1967 · N7012U · Minor damage NTSB CHI68F0167Accident · Minor injuriesClosedCessna 182 · Northbrook, ILJun 7, 1967 · N3268S · Substantial damage NTSB CHI68F0126Accident · Minor injuriesClosedCessna 140 · Roselle, ILJun 6, 1967 · N241V · Destroyed NTSB CHI68D0483Accident · Minor injuriesClosedPiper PA-22 · Carman, ILJun 4, 1967 · N3525P · Substantial damage NTSB CHI68D0320Accident · No injuriesClosedBeech A23 · Rockford, ILJun 4, 1967 · N4724J · Substantial damage NTSB CHI68F0139Accident · Minor injuriesClosedPiper PA-28 · Chicago, ILJun 3, 1967 · N7280W · Substantial damage NTSB CHI68D0335Accident · No injuriesClosedPorterfield LP-65 · Lombard, ILJun 3, 1967 · N34706 · Substantial damage NTSB CHI68D0310Accident · No injuriesClosedCessna 150 · East Alton, ILJun 2, 1967 · N6547F · Substantial damage NTSB CHI68D0057Accident · No injuriesClosedAero Comdr 560-E · Wheeling, ILMay 31, 1967 · N701W · No damage NTSB CHI68F0092Accident · No injuriesClosedAeronca 7AC · Elgin, ILMay 29, 1967 · N83049 · Substantial damage NTSB CHI68D0354Accident · No injuriesClosedBeech 95 · Joliet, ILMay 29, 1967 · N9631R · Substantial damage NTSB CHI68D0058Accident · No injuriesClosedCessna 182 · Savanna, ILMay 29, 1967 · N3556Y · Substantial damage NTSB CHI68D0484Accident · No injuriesClosedCessna 150 · Lawrenceville, ILMay 27, 1967 · N3748J · Substantial damage NTSB CHI68D0008Accident · No injuriesClosedBeech B35 · Mattoon, ILMay 27, 1967 · N9754R · Substantial damage NTSB CHI68F0135Accident · No injuriesClosedPiper PA-24 · Valmeyer, ILMay 25, 1967 · N8074P · Substantial damage NTSB CHI68D0038Accident · No injuriesClosedPiper PA-23 · Elgin, ILMay 24, 1967 · N5902Z · Substantial damage NTSB CHI68D0107Accident · No injuriesClosedPiper PA-28 · Northbrook, ILMay 21, 1967 · N9175W · Substantial damage NTSB CHI68D0471Accident · No injuriesClosedCessna 172F · Bloomington, ILMay 19, 1967 · N5327R · Substantial damage NTSB CHI68D0248Accident · No injuriesClosedPiper J4E · Streator, ILMay 18, 1967 · N41058 · Substantial damage NTSB CHI68D0059Accident · No injuriesClosedCessna 182 · Chicago, ILMay 18, 1967 · N2987F · Substantial damage NTSB CHI68D0082Accident · No injuriesClosedBeech H35 · Chicago, ILMay 15, 1967 · N7908D · Substantial damage NTSB CHI67F0622Accident · Minor injuriesClosedErcoupe 415CD · Wyoming, ILMay 14, 1967 · N3866H · Substantial damage NTSB CHI67D0654Accident · No injuriesClosedBeech A23 · Polo, ILMay 13, 1967 · N8773M · Substantial damage NTSB MKC67A0066Accident · No injuriesClosedN.American NA-265 · East Alton, ILMay 11, 1967 · N2007 · Substantial damage NTSB CHI67D0648Accident · No injuriesClosedCessna 172 · Plainville, ILMay 9, 1967 · N2181Y · Substantial damage NTSB CHI68D0138Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILMay 7, 1967 · N2831Z · Substantial damage NTSB CHI68D0036Accident · No injuriesClosedPiper PA-22 · Grayslake, ILMay 7, 1967 · N2330P · Substantial damage NTSB CHI68F0293Accident · No injuriesClosedMooney M20 · Richton Park, ILMay 1, 1967 · N5226B · Substantial damage NTSB CHI68D0037Accident · No injuriesClosedPiper PA-22 · Rockford, ILMay 1, 1967 · N7438D · Substantial damage NTSB CHI67D0607Accident · No injuriesClosedBeech 35 · Compton, ILApr 23, 1967 · N2804V · Substantial damage NTSB CHI67D0621Accident · No injuriesClosedCessna 172 · Peoria, ILApr 17, 1967 · N2021X · Substantial damage NTSB CHI68F0465Accident · No injuriesClosedCessna 150 · Charleston, ILApr 16, 1967 · N3499J · Substantial damage NTSB CHI67F0679Accident · No injuriesClosedCessna 182 · Columbia, ILApr 15, 1967 · N5871B · Substantial damage NTSB CHI67F0657Accident · No injuriesClosedMooney M20A · Chicago, ILApr 15, 1967 · N6030X · Substantial damage NTSB CHI67A0117Accident · No injuriesClosedN.American NA-260 · Rosemont, ILApr 14, 1967 · N600R · Substantial damage NTSB CHI67D0637Accident · No injuriesClosedBeech 35-33 · Elgin, ILApr 9, 1967 · N5654K · Substantial damage