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 CHI72FEV01Accident · Serious injuriesClosedChampion 7AC · Breese, ILJul 1, 1971 · N2515E · Destroyed NTSB CHI71FEV50Accident · Serious injuriesClosedChampion 7KCAB · Aledo, ILJun 28, 1971 · N5194T · Destroyed NTSB CHI71FEE90Accident · No injuriesClosedBell 47G-4A · Chicago, ILJun 28, 1971 · N4033G · Substantial damage NTSB CHI71DEE91Accident · No injuriesClosedPiper PA-28 · Midlothian, ILJun 27, 1971 · N8225N · Substantial damage NTSB CHI71FEE87Accident · Serious injuriesClosedPiper PA-28 · Morris, ILJun 21, 1971 · N9613W · Substantial damage NTSB CHI71FEV48Accident · No injuriesClosedCessna 206 · Pekin, ILJun 20, 1971 · N2516X · Substantial damage NTSB CHI71FCA07Accident · Minor injuriesClosedAero Comdr 100 · Cahokia, ILJun 17, 1971 · N3731X · Destroyed NTSB CHI71DEV49Accident · No injuriesClosedCessna 172 · Palestine, ILJun 14, 1971 · N6646A · Substantial damage NTSB CHI71FEE88Accident · No injuriesClosedLuscombe 8A · Plainfield, ILJun 13, 1971 · N71373 · Substantial damage NTSB CHI71DEE89Accident · No injuriesClosedCessna 172 · Hinsdale, ILJun 11, 1971 · N79897 · Substantial damage NTSB CHI71DEE86Accident · No injuriesClosedCessna 140 · Earlville, ILJun 11, 1971 · N76644 · Substantial damage NTSB CHI71DEE85Accident · No injuriesClosedMooney M22 · Crestwood, ILJun 8, 1971 · N7730M · Substantial damage NTSB CHI71FEE76Accident · No injuriesClosedCessna 411 · Northbrook, ILJun 7, 1971 · N256EL · Substantial damage NTSB CHI71DEE92Accident · No injuriesClosedTaylorcraft DL-65 · Stockton, ILJun 5, 1971 · N27470 · Substantial damage NTSB CHI71FEE84Accident · No injuriesClosedCessna 310C · Waukegan, ILJun 3, 1971 · N585KM · Substantial damage NTSB CHI71DEE83Accident · No injuriesClosedPiper PA-28 · Roselle, ILJun 3, 1971 · N9782W · Substantial damage NTSB CHI71DEE81Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 2, 1971 · N5904T · 2 aircraft · Substantial damage NTSB CHI71DEV47Accident · No injuriesClosedCessna 172B · Sparta, ILJun 1, 1971 · N6922X · Substantial damage NTSB CHI71DEE79Accident · No injuriesClosedAmer Avco AA1 · Pecatonica, ILMay 30, 1971 · N5621L · Substantial damage NTSB CHI71FCA06Accident · Minor injuriesClosedCessna 172I · Bethalto, ILMay 28, 1971 · N8452L · Substantial damage NTSB CHI71DEE80Accident · No injuriesClosedCoppock SA-100 · Crystal Lake, ILMay 27, 1971 · N2581 · Destroyed NTSB CHI71FEE75Accident · Minor injuriesClosedWaco M220-4 · Lansing, ILMay 23, 1971 · N4702W · Substantial damage NTSB CHI71DEE93Accident · No injuriesClosedSchwiezer 1-26B · Naperville, ILMay 22, 1971 · N688U · Substantial damage NTSB CHI71FEE74Accident · No injuriesClosedBoeing A75N1 · Wauconda, ILMay 21, 1971 · N4786N · Destroyed NTSB CHI71DEV45Accident · No injuriesClosedAer-Pegaso M-100S · Greenup, ILMay 20, 1971 · N8728R · Substantial damage NTSB CHI71FEV41Accident · No injuriesClosedPiper PA-18 · Sheldon, ILMay 16, 1971 · N223T · Minor damage NTSB CHI71FEV44Accident · Serious injuriesClosedAeronca 65-TAL · Abingdon, ILMay 15, 1971 · N39373 · Substantial damage NTSB CHI71DEE82Accident · No injuriesClosedBeech B23 · Joliet, ILMay 15, 1971 · N6069N · Substantial damage NTSB CHI71FEV43Accident · No injuriesClosedCessna 120 · Kenney, ILMay 14, 1971 · N73U · Substantial damage NTSB CHI71FEV42Accident · Minor injuriesClosedPiper PA-25 · Vandalia, ILMay 10, 1971 · N6872Z · Destroyed NTSB CHI71FEV40Accident · No injuriesClosedCessna 150 · Manito, ILMay 10, 1971 · N3821J · Substantial damage NTSB CHI71DEE77Accident · No injuriesClosedGlobe GC-1B · Kankakee, ILMay 9, 1971 · N80605 · Substantial damage NTSB CHI71FEE78Accident · No injuriesClosedCessna 337 · Serena, ILMay 8, 1971 · N86284 · Substantial damage NTSB CHI71FCA05Accident · No injuriesClosedPiper PA-28 · Collinsville, ILMay 6, 1971 · N4538R · Substantial damage NTSB CHI71DEE73Accident · No injuriesClosedPiper PA-28 · Lansing, ILMay 6, 1971 · N95472 · Substantial damage NTSB CHI71FEE71Accident · No injuriesClosedCessna 421 · Chicago, ILMay 5, 1971 · N4073L · Substantial damage NTSB CHI71DEV39Accident · No injuriesClosedCessna 170B · Peoria, ILApr 29, 1971 · N8293A · Substantial damage NTSB CHI71IC081Incident · No injuriesClosedLear Jet 23 · Chicago, ILApr 28, 1971 · N400RB · Minor damage NTSB CHI71DEE69Accident · No injuriesClosedBeech A23-19 · Crystal Lake, ILApr 27, 1971 · N5987S · Substantial damage NTSB CHI71DEV46Accident · No injuriesClosedCessna 182L · Flora, ILApr 24, 1971 · N42683 · Substantial damage NTSB CHI71FEV38Accident · No injuriesClosedPiper PA-28 · Centralia, ILApr 23, 1971 · N6944W · Substantial damage NTSB CHI71DBQ37Accident · No injuriesClosedCessna 177 · Savoy, ILApr 23, 1971 · N30195 · Substantial damage NTSB CHI71DEE67Accident · No injuriesClosedMooney M20A · Schaumburg, ILApr 21, 1971 · N8301E · Substantial damage NTSB CHI71FBD65Accident · 1 fatalClosedPiper PA-28 · Kewanee, ILApr 19, 1971 · N6418R · Substantial damage NTSB CHI71DEE70Accident · No injuriesClosedCessna 177 · Buda, ILApr 19, 1971 · N3137T · Substantial damage NTSB CHI71FBQ36Accident · No injuriesClosedCessna 172 · Manito, ILApr 17, 1971 · N35753 · Substantial damage NTSB CHI71DEE66Accident · No injuriesClosedAero-Comdr 100 · Mendota, ILApr 17, 1971 · N2952T · Substantial damage NTSB CHI71FBQ35Accident · No injuriesClosedLear Jet 23 · Danville, ILApr 10, 1971 · N658L · Substantial damage NTSB CHI71DBD64Accident · No injuriesClosedCessna 170 · Rockford, ILApr 10, 1971 · N3487D · Substantial damage NTSB CHI71AC072Accident · Serious injuriesClosedPiper PA-32 · Hinsdale, ILApr 5, 1971 · N3384W · 2 aircraft · Destroyed