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 UNK64X3918Accident · No injuriesClosedCessna 140 · Chicago, ILSep 11, 1964 · N89049 · Substantial damage NTSB UNK64X3835Accident · 3 fatalClosedPiper PA23 · Markham, ILSep 6, 1964 · N1252P · Destroyed NTSB UNK64X3766Accident · No injuriesClosedPiper PA24 · Hinsdale, ILSep 4, 1964 · N7767P · Substantial damage NTSB UNK64X3761Accident · No injuriesClosedCessna 172E · Champaign, ILSep 4, 1964 · N5715T · Substantial damage NTSB UNK64X3727Accident · No injuriesClosedCessna 140 · Northbrook, ILSep 1, 1964 · N89918 · Substantial damage NTSB UNK64X3697Accident · No injuriesClosedCessna 310C · Joliet, ILAug 31, 1964 · N1822H · Substantial damage NTSB UNK64X3674Accident · No injuriesClosedBeechcraft M23 · Milan, ILAug 29, 1964 · N8748M · Substantial damage NTSB UNK64X3651Accident · No injuriesClosedBeechcraft S35 · Rockford, ILAug 28, 1964 · N5716K · Substantial damage NTSB UNK64X3609Accident · No injuriesClosedPiper PA22 · Chicago, ILAug 26, 1964 · N5846Z · Substantial damage NTSB UNK64X3601Accident · No injuriesClosedStinson 108-2 · Sterling, ILAug 26, 1964 · N9666K · Substantial damage NTSB UNK64X3589Accident · No injuriesClosedCessna 120 · West Salem, ILAug 25, 1964 · N76542 · Substantial damage NTSB UNK64X3529Accident · No injuriesClosedPiper J3 · Kewanee, ILAug 22, 1964 · N5300K · Substantial damage NTSB UNK64X3480Accident · Minor injuriesClosedCessna 175 · Mcnabb, ILAug 19, 1964 · N6919E · Substantial damage NTSB UNK64X3456Accident · No injuriesClosedNavion 205 · E St Louis, ILAug 18, 1964 · N4791K · Substantial damage NTSB UNK64X3443Accident · 1 fatalClosedJ-Parsons 260 · Lake Villa, ILAug 17, 1964 · N4030A · Destroyed NTSB UNK64X3396Accident · No injuriesClosedBeech C-45F · Kankakee, ILAug 15, 1964 · N12068 · Destroyed NTSB UNK64X3379Accident · Minor injuriesClosedErcoupe 415C · Lansing, ILAug 14, 1964 · N87101 · Substantial damage NTSB UNK64X3364Accident · No injuriesClosedChampion 7FC · Grayville, ILAug 13, 1964 · N4835G · Substantial damage NTSB UNK64X3282Accident · Serious injuriesClosedChampion 7AC · Rockford, ILAug 8, 1964 · N1510E · Destroyed NTSB UNK64X3236Accident · No injuriesClosedPiper PA18A · Mendota, ILAug 6, 1964 · N4478A · Substantial damage NTSB UNK64X3234Accident · No injuriesClosedCessna 195 · Morris, ILAug 6, 1964 · N1053D · Substantial damage NTSB UNK64X3208Accident · Minor injuriesClosedPiper J3 · Wheeling, ILAug 4, 1964 · N70154 · Destroyed NTSB UNK64X3183Accident · No injuriesClosedPiper PA22 · Wheeling, ILAug 2, 1964 · N5602Z · Substantial damage NTSB UNK64X3163Accident · Minor injuriesClosedAeronca 7AC · Bartlett, ILAug 2, 1964 · N4431E · Destroyed NTSB UNK64X3142Accident · No injuriesClosedPiper PA22 · Mattoon, ILAug 1, 1964 · N5930Z · Substantial damage NTSB UNK64X3137Accident · No injuriesClosedPiper PA23 · Quincy, ILJul 31, 1964 · N4150P · Substantial damage NTSB UNK64X3109Accident · No injuriesClosedBeechcraft 35B33 · Mt Olive, ILJul 29, 1964 · N946Q · Substantial damage NTSB UNK64X3108Accident · No injuriesClosedPiper PA22 · Wheeling, ILJul 29, 1964 · N1222C · Substantial damage NTSB UNK64X3099Accident · Minor injuriesClosedCessna 150 · Wheeling, ILJul 29, 1964 · N4537U · Substantial damage NTSB UNK64X3089Accident · No injuriesClosedPiper PA24 · Chicago, ILJul 28, 1964 · N5826P · Substantial damage NTSB UNK64X3088Accident · No injuriesClosedCessna 320 · Peoria, ILJul 28, 1964 · N5716X · Substantial damage NTSB UNK64X3054Accident · No injuriesClosedErcoupe 415C · Chicago, ILJul 26, 1964 · N93361 · Destroyed NTSB UNK64X3045Accident · No injuriesClosedBeechcraft P35 · Chicago, ILJul 26, 1964 · N1544Z · Substantial damage NTSB UNK64X3007Accident · Minor injuriesClosedCessna 172 · Fairbury, ILJul 24, 1964 · N2816S · Destroyed NTSB UNK64X2995Accident · No injuriesClosedBeechcraft A35 · West Chicago, ILJul 23, 1964 · N713B · Substantial damage NTSB UNK64X2968Accident · No injuriesClosedPiper J3 · Wheeling, ILJul 22, 1964 · N98261 · 2 aircraft · Substantial damage NTSB UNK64X2919Accident · No injuriesClosedCessna 195 · Tinley Park, ILJul 19, 1964 · N3433V · Destroyed NTSB UNK64X2886Accident · 1 fatalClosedPiper PA-22 · Joliet, ILJul 17, 1964 · N9232D · Substantial damage NTSB UNK64X2872Accident · No injuriesClosedBeechcraft C35 · Northbrook, ILJul 17, 1964 · N731D · Substantial damage NTSB UNK64X2810Accident · No injuriesClosedPiper PA22 · Iola, ILJul 13, 1964 · N879A · Substantial damage NTSB UNK64X2799Accident · No injuriesClosedBeechcraft D18 · Springfield, ILJul 13, 1964 · N43D · Substantial damage NTSB UNK64X2751Accident · No injuriesClosedPiper PA28 · Midlothian, ILJul 10, 1964 · N8694W · Substantial damage NTSB UNK64X2737Accident · No injuriesClosedBeech D35 · Joliet, ILJul 9, 1964 · N3425B · Substantial damage NTSB UNK64X2703Accident · No injuriesClosedBeechcraft 17 · Lake Villa, ILJul 7, 1964 · N1178V · Substantial damage NTSB UNK64X2695Accident · No injuriesClosedPiper PA30 · Lansing, ILJul 7, 1964 · N7139Y · Substantial damage NTSB UNK64X2689Accident · No injuriesClosedPiper PA28 · Kansas, ILJul 6, 1964 · N5639W · Substantial damage NTSB UNK64X2652Accident · No injuriesClosedCessna 140 · Marissa, ILJul 5, 1964 · N89838 · Substantial damage NTSB UNK64X2599Accident · Minor injuriesClosedHughes 269A · Andalusia, ILJul 1, 1964 · N8748F · Destroyed NTSB UNK64X2596Accident · Minor injuriesClosedHoward DGA15P · Pekin, ILJul 1, 1964 · N9843H · Substantial damage NTSB UNK64X2565Accident · No injuriesClosedCessna 210 · Chicago, ILJun 29, 1964 · N9582X · Substantial damage