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 CHI77FEE25Accident · No injuriesClosedCessna 150 · West Chicago, ILJun 16, 1977 · N704XZ · Substantial damage NTSB CHI77DEV28Accident · Minor injuriesClosedChampion 7EC · Urbana, ILJun 14, 1977 · N9905Y · Substantial damage NTSB CHI77FA050Accident · 1 fatalClosedCessna 150H · Benton, ILJun 13, 1977 · N7087S · Destroyed NTSB CHI77FEV27Accident · 1 fatalClosedTolman SA-3AM · Salem, ILJun 11, 1977 · N1054 · Destroyed NTSB CHI77DEE26Accident · No injuriesClosedPiper PA-24 · Sandwich, ILJun 10, 1977 · N8840P · Substantial damage NTSB CHI77FEV26Accident · Serious injuriesClosedPiper J-3 · Manito, ILJun 4, 1977 · N70907 · Substantial damage NTSB CHI77IA047Incident · No injuriesClosedDouglas DC-10 · Chicago, ILJun 2, 1977 · N1833U · Minor damage NTSB CHI77FEE23Accident · Minor injuriesClosedPiper PA-23 · Streator, ILMay 26, 1977 · N5957Y · Substantial damage NTSB CHI77DEE24Accident · No injuriesClosedCessna 182 · Elgin, ILMay 24, 1977 · N6146B · Substantial damage NTSB CHI77FA044Accident · 1 fatalClosedCessna 172 · East Dundee, ILMay 22, 1977 · N8031B · Destroyed NTSB CHI77FEV25Accident · No injuriesClosedBeech A35 · Peoria, ILMay 19, 1977 · N8505A · Substantial damage NTSB CHI77FEV24Accident · Minor injuriesClosedCessna A188B · Paris, ILMay 19, 1977 · N53330 · Substantial damage NTSB CHI77FEE21Accident · Minor injuriesClosedGlobe GC-1B · Marengo, ILMay 14, 1977 · N187WE · Substantial damage NTSB CHI77DEE22Accident · No injuriesClosedCessna 150 · Lansing, ILApr 30, 1977 · N9235U · Substantial damage NTSB CHI77FA041Accident · Serious injuriesClosedN.American NA-265 · Wheeling, ILApr 27, 1977 · N6NR · Destroyed NTSB CHI77FEE20Accident · No injuriesClosedNavion A · Schaumburg, ILApr 26, 1977 · N4503K · Substantial damage NTSB CHI77FA040Accident · 4 fatalClosedAero Comdr 690A · Chicago, ILApr 23, 1977 · N847 · Destroyed NTSB CHI77FEE17Accident · No injuriesClosedCessna 177B · Illinois City, ILApr 18, 1977 · N34515 · Substantial damage NTSB CHI77FEE18Accident · Minor injuriesClosedAero Comdr 112A · Half Day, ILApr 17, 1977 · N1346J · Substantial damage NTSB CHI77FEE19Accident · Minor injuriesClosedCessna 150M · Kankakee, ILApr 16, 1977 · N45127 · Substantial damage NTSB CHI77DEV20Accident · No injuriesClosedCessna 150 · Thompsonville, ILApr 16, 1977 · N23127 · Substantial damage NTSB CHI77FEV22Accident · Minor injuriesClosedBell 47G5 · Enfield, ILApr 15, 1977 · N8142J · Destroyed NTSB CHI77FEV21Accident · No injuriesClosedRockwell 500B · Mt.Vernon, ILApr 14, 1977 · N90540 · Substantial damage NTSB CHI77DCA03Accident · Minor injuriesClosedCessna 150M · Alton, ILApr 14, 1977 · N704KK · Substantial damage NTSB CHI77FEV19Accident · Serious injuriesClosedSnow S2B · Belle Rive, ILApr 12, 1977 · N6175U · Destroyed NTSB CHI77FEV23Accident · No injuriesClosedCessna 210-5A · Shawneetown, ILApr 10, 1977 · N8494Z · Substantial damage NTSB CHI77FEV18Accident · No injuriesClosedCessna 150M · Springfield, ILApr 8, 1977 · N9483U · Substantial damage NTSB CHI77DEE14Accident · No injuriesClosedStinson 108-1 · Rockford, ILApr 3, 1977 · N8863K · Substantial damage NTSB CHI77FEV17Accident · No injuriesClosedCessna 175A · Quincy, ILApr 2, 1977 · N101MB · Substantial damage NTSB CHI77FA038Accident · 2 fatalClosedBrantly B-2 · Tremont, ILApr 2, 1977 · N2131U · Destroyed NTSB CHI77FEE15Accident · No injuriesClosedCessna 150L · Sandwich, ILMar 31, 1977 · N11740 · Substantial damage NTSB CHI77DEV16Accident · No injuriesClosedCessna 172 · Quincy, ILMar 30, 1977 · N61834 · Substantial damage NTSB CHI77DEE16Accident · No injuriesClosedGrumman AA5 · Frankfort, ILMar 30, 1977 · N74406 · Substantial damage NTSB CHI77DEE13Accident · No injuriesClosedCessna 172K · Moline, ILMar 30, 1977 · N7084G · Substantial damage NTSB CHI77FEV15Accident · No injuriesClosedCessna 177RG · Springfield, ILMar 27, 1977 · N7584V · Substantial damage NTSB CHI77FA036Accident · 2 fatalClosedBeech 23 · Morris, ILMar 19, 1977 · N2309Z · Destroyed NTSB CHI77FEE12Accident · Serious injuriesClosedBeech A90 · Kankakee, ILMar 10, 1977 · N34F · Substantial damage NTSB CHI77FA034Accident · 1 fatalClosedPiper PA-28 · Chicago, ILMar 6, 1977 · N40922 · Destroyed NTSB CHI77FA033Accident · 4 fatalClosedMooney M20E · St Charles, ILMar 3, 1977 · N1947Y · Destroyed NTSB CHI77FEE10Accident · No injuriesClosedPiper PA-23 · Streator, ILMar 2, 1977 · N6050Y · Substantial damage NTSB CHI77FEV14Accident · No injuriesClosedCessna 182P · Petersburg, ILMar 1, 1977 · N1483S · Substantial damage NTSB CHI77DEE11Accident · No injuriesClosedCessna 150L · Chicago, ILFeb 27, 1977 · N11789 · Substantial damage NTSB CHI77FEV13Accident · No injuriesClosedCessna 172K · Jerseyville, ILFeb 16, 1977 · N7115G · Substantial damage NTSB CHI77DEV12Accident · No injuriesClosedCessna 150M · Lawrenceville, ILFeb 15, 1977 · N66378 · Substantial damage NTSB CHI77FA028Accident · 4 fatalClosedPiper PA-32 · Sugar Grove, ILFeb 12, 1977 · N31CA · Destroyed NTSB CHI77FA027Accident · No injuriesClosedCessna 402A · Peoria, ILFeb 7, 1977 · N87275 · Substantial damage NTSB CHI77FEV11Accident · No injuriesClosedPiper PA-24 · Tolono, ILFeb 5, 1977 · N7440P · Substantial damage NTSB CHI77FEV10Accident · No injuriesClosedCessna 150 · Manito, ILFeb 3, 1977 · N65981 · Substantial damage NTSB CHI77FEV09Accident · No injuriesClosedCessna 150 · Peoria, ILJan 29, 1977 · N9336U · Substantial damage NTSB CHI77FCA02Accident · No injuriesClosedBellanca 7ECA · Cahokia, ILJan 24, 1977 · N36032 · Substantial damage