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 CHI73AC043Accident · 6 fatalClosedAero Comdr 500-A · Pekin, ILOct 23, 1972 · N78376 · Destroyed NTSB CHI73DEE26Accident · No injuriesClosedPiper PA-28 · New Lenox, ILOct 15, 1972 · N4408J · Substantial damage NTSB CHI73AC040Accident · 2 fatalClosedPiper PA-28R · Bloomington, ILOct 14, 1972 · N2831R · Destroyed NTSB CHI73ACO39Accident · 1 fatalClosedN. American SNJ-6 · Woodstock, ILOct 9, 1972 · N7984C · Substantial damage NTSB CHI73ACO37Accident · No injuriesClosedBeech SNB-5 · Chicago, ILOct 5, 1972 · N3787A · Substantial damage NTSB CHI73FCA01Accident · Serious injuriesClosedPiper PA-25 · Dorsey, ILSep 30, 1972 · N7247Z · Substantial damage NTSB CHI73A0023Accident · No injuriesClosedDouglas DC9-32 · Chicago, ILSep 28, 1972 · N3329L · Substantial damage NTSB CHI73DEV12Accident · No injuriesClosedCessna 310G · Fairfield, ILSep 25, 1972 · N8900Z · Substantial damage NTSB CHI73FET06Accident · Minor injuriesClosedAlon A2 · Ligonier, ILSep 24, 1972 · N5686F · Substantial damage NTSB CHI73FEE24Accident · Serious injuriesClosedCessna 172 · Morrison, ILSep 24, 1972 · N6361E · Destroyed NTSB CHI73DEE25Accident · No injuriesClosedRyan PT-22 · Stockton, ILSep 24, 1972 · N60170 · Substantial damage NTSB CHI73AC033Accident · 4 fatalClosedCessna 337B · Chicago, ILSep 17, 1972 · N528N · Substantial damage NTSB CHI73FEV11Accident · No injuriesClosedPiper PA-24 · Jacksonville, ILSep 11, 1972 · N8793P · Substantial damage NTSB CHI72FEV33Accident · Serious injuriesClosedPiper PA-22 · Warsaw, ILSep 9, 1972 · N601A · Destroyed NTSB CHI73FEV10Accident · No injuriesClosedChampion 7ECA · Pittsfield, ILSep 4, 1972 · N5169X · Substantial damage NTSB CHI73FEV09Accident · Minor injuriesClosedStinson 108-1 · Virginia, ILSep 4, 1972 · N9009K · Substantial damage NTSB CHI73DEV13Accident · No injuriesClosedAero Comdr A-9B · Jacksonville, ILSep 4, 1972 · N7965V · Substantial damage NTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILSep 3, 1972 · N5677U · Substantial damage NTSB CHI73DEE21Accident · No injuriesClosedCessna 177A · Moline, ILAug 28, 1972 · N30475 · Substantial damage NTSB CHI73FEE19Accident · No injuriesClosedCessna 150H · Deerfield, ILAug 25, 1972 · N7287S · Substantial damage NTSB CHI73FEV08Accident · No injuriesClosedPiper PA-25 · Browns, ILAug 23, 1972 · N8807L · Substantial damage NTSB CHI73DEE20Accident · Minor injuriesClosedPiper PA-28 · Park Forest, ILAug 20, 1972 · N5858W · Substantial damage NTSB CHI73FEE18Accident · No injuriesClosedCessna 150G · Shannon, ILAug 14, 1972 · N2823S · Substantial damage NTSB CHI73AC017Accident · No injuriesClosedFairchild FH227B · Chicago, ILAug 14, 1972 · N4226 · Substantial damage NTSB CHI73FEV07Accident · Serious injuriesClosedPiper PA-25 · Brookport, ILAug 13, 1972 · N4552Y · Destroyed NTSB CHI73AC015Accident · No injuriesClosedN.American NA-265 · Chicago, ILAug 13, 1972 · N620M · Substantial damage NTSB CHI73FEE17Accident · No injuriesClosedBeech 35-B33 · Joliet, ILAug 12, 1972 · N8621M · Substantial damage NTSB CHI73FEE16Accident · No injuriesClosedPiper PA-28 · Lake Zurich, ILAug 12, 1972 · N5086W · Substantial damage NTSB CHI73DEE23Accident · No injuriesClosedBoeing B75N1 · Wheeling, ILAug 12, 1972 · N5404N · Substantial damage NTSB CHI73DEE15Accident · No injuriesClosedCessna 150G · Naperville, ILAug 12, 1972 · N2951J · Substantial damage NTSB CHI73FEE12Accident · No injuriesClosedCessna 172K · Lincolnshire, ILAug 11, 1972 · N7410G · Substantial damage NTSB CHI73FEE14Incident · No injuriesClosedPiper PA-24 · Rockford, ILAug 7, 1972 · N6460P · Minor damage NTSB CHI73FEE11Accident · Serious injuriesClosedPiper PA-12 · Maple Park, ILAug 6, 1972 · N7774H · Substantial damage NTSB CHI73AC011Accident · 1 fatalClosedPiper J3C-65 · Granite City, ILAug 6, 1972 · N6493H · Substantial damage NTSB CHI73IC010Incident · No injuriesClosedDouglas DC-10 · Moline, ILAug 4, 1972 · N1806U · No damage NTSB CHI73FEE13Accident · No injuriesClosedPiper PA-24 · Sandwich, ILAug 4, 1972 · N9174P · Substantial damage NTSB CHI73FEE10Accident · Minor injuriesClosedCessna 172 · Streator, ILAug 4, 1972 · N8096B · Substantial damage NTSB CHI73DEV06Accident · No injuriesClosedCessna 150L · Mattoon, ILJul 29, 1972 · N6690G · Substantial damage NTSB CHI73DEV05Accident · No injuriesClosedBell 47G-2 · Murdock, ILJul 23, 1972 · N12848 · Substantial damage NTSB CHI73FEV03Accident · No injuriesClosedErcoupe 415C · Champaign, ILJul 18, 1972 · N28962 · Substantial damage NTSB CHI73DEV04Accident · No injuriesClosedCessna 120 · Coffeen, ILJul 18, 1972 · N89666 · Substantial damage NTSB CHI73DEE07Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILJul 18, 1972 · N3279B · Substantial damage NTSB CHI73FEE08Accident · No injuriesClosedPitts Spcl SC-1 · Aurora, ILJul 16, 1972 · N87V · Substantial damage NTSB CHI73DEV02Accident · Minor injuriesClosedStinson 108-1 · Clinton, ILJul 16, 1972 · N97104 · Substantial damage NTSB CHI73FEE05Accident · No injuriesClosedCessna 310J · West Chicago, ILJul 12, 1972 · N3175L · Substantial damage NTSB CHI73FEE02Accident · No injuriesClosedMooney M20C · Joliet, ILJul 12, 1972 · N9449V · Substantial damage NTSB CHI73FEE03Accident · Serious injuriesClosedLuscombe 8A · Minooka, ILJul 10, 1972 · N71682 · Substantial damage NTSB CHI73FEE06Accident · No injuriesClosedMaule M-4 · Wheeling, ILJul 8, 1972 · N4730T · Substantial damage NTSB CHI73FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILJul 8, 1972 · N7346J · Substantial damage NTSB CHI73FEE01Accident · No injuriesClosedCessna 140 · Harvard, ILJul 4, 1972 · N89325 · Substantial damage