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 CHI72DEE36Accident · No injuriesClosedChampion 7EC · Lasalle, ILSep 24, 1971 · N7459B · Substantial damage NTSB CHI72FEE28Accident · Serious injuriesClosedBell 47G-4A · Chicago, ILSep 22, 1971 · N4033G · Substantial damage NTSB CHI72FEE26Incident · No injuriesClosedPiper PA-24 · Rock Falls, ILSep 20, 1971 · N9065P · Minor damage NTSB CHI72DEE34Accident · No injuriesClosedCessna 310B · Rockford, ILSep 17, 1971 · N125ET · Substantial damage NTSB CHI72DEE27Accident · No injuriesClosedPiper PA-24 · Waukegan, ILSep 13, 1971 · N7232P · Substantial damage NTSB CHI72FEE22Accident · No injuriesClosedStinson 108 · West Chicago, ILSep 7, 1971 · N26448 · Substantial damage NTSB CHI72AC023Accident · Serious injuriesClosedDouglas DC-3 · Peotone, ILSep 6, 1971 · N44992 · Minor damage NTSB CHI72DEE23Accident · No injuriesClosedBeech C35 · Dekalb, ILSep 3, 1971 · N654D · Substantial damage NTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILSep 1, 1971 · N5875U · Substantial damage NTSB CHI72DEE25Accident · No injuriesClosedSiai-Marche S205 · Northbrook, ILAug 30, 1971 · N2832W · Substantial damage NTSB CHI72DEE21Accident · No injuriesClosedCessna 180 · Wheeling, ILAug 29, 1971 · N3868C · Substantial damage NTSB CHI72FEV14Accident · No injuriesClosedPiper PA-25 · Fisher, ILAug 24, 1971 · N4772Y · Substantial damage NTSB CHI72FEE18Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILAug 22, 1971 · N6652W · Substantial damage NTSB CHI72FEE17Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILAug 22, 1971 · N8415R · Substantial damage NTSB CHI72FEE16Accident · Minor injuriesClosedErco 415-C · Plainfield, ILAug 21, 1971 · N3088H · Substantial damage NTSB CHI72DEE20Accident · Minor injuriesClosedBeech V35 · Plainfield, ILAug 20, 1971 · N8452J · Substantial damage NTSB CHI72DEV15Accident · No injuriesClosedPiper PA-28 · Cropsey, ILAug 18, 1971 · N5233L · Substantial damage NTSB CHI72FEV13Accident · No injuriesClosedCessna 150 · Manito, ILAug 16, 1971 · N6510S · Substantial damage NTSB CHI72FEE15Accident · No injuriesClosedPiper PA-28 · Grayslake, ILAug 16, 1971 · N5691U · Substantial damage NTSB CHI72DEE13Accident · No injuriesClosedThurston TSC-1A · Fox Lake, ILAug 16, 1971 · N2006T · Substantial damage NTSB CHI72FEV12Accident · Serious injuriesClosedSmith-Mini DSA-1 · Smithfield, ILAug 15, 1971 · N175N · Substantial damage NTSB CHI72FEV11Accident · No injuriesClosedPitts Spec. SC-1 · Smithfield, ILAug 15, 1971 · N230K · Substantial damage NTSB CHI72FEE19Accident · No injuriesClosedCessna 150J · Grayslake, ILAug 14, 1971 · N61349 · Minor damage NTSB CHI72FEV10Accident · Minor injuriesClosedCessna 310F · Urbana, ILAug 12, 1971 · N6769X · Substantial damage NTSB CHI72AC013Accident · 2 fatalClosedBell 47G2A1 · Bellwood, ILAug 10, 1971 · N73989 · Destroyed NTSB CHI72DEE12Accident · No injuriesClosedPiper PA-24 · Grayslake, ILAug 7, 1971 · N5320P · Substantial damage NTSB CHI72FEV08Accident · No injuriesClosedPiper PA-30 · Bloomington, ILAug 6, 1971 · N7696Y · Substantial damage NTSB CHI72FEE11Accident · Minor injuriesClosedUniv Acft D-16 · Gilberts, ILAug 5, 1971 · N88N · Substantial damage NTSB CHI72DEE14Accident · Minor injuriesClosedVolmer Amphib · Evanston, ILAug 2, 1971 · N2519 · Substantial damage NTSB CHI72FEV07Accident · No injuriesClosedPiper PA-25 · Carthage, ILJul 31, 1971 · N7014Z · Substantial damage NTSB CHI72FEE10Accident · Serious injuriesClosedAero Comdr 100 · Rockford, ILJul 31, 1971 · N3606X · Destroyed NTSB CHI72DEY06Accident · Minor injuriesClosedCessna 150F · Carbondale, ILJul 31, 1971 · N8028F · Substantial damage NTSB CHI72FEE09Accident · 1 fatalClosedPiper PA-28 · Western Spgs, ILJul 28, 1971 · N98008 · Destroyed NTSB CHI72DEV05Accident · No injuriesClosedPiper PA-28 · Wapella, ILJul 24, 1971 · N8242N · Substantial damage NTSB CHI72AC009Accident · 2 fatalClosedCessna 182K · Springfield, ILJul 23, 1971 · N7600K · Destroyed NTSB CHI72AC008Accident · Serious injuriesClosedBoeing 747 · Chicago, ILJul 23, 1971 · N4713U · Minor damage NTSB CHI72FEE08Accident · No injuriesClosedCessna 310 · Ottawa, ILJul 20, 1971 · N2923R · Substantial damage NTSB CHI72DEV04Accident · No injuriesClosedSchweizer SGS126 · Mulberry Grve, ILJul 20, 1971 · N8652R · Substantial damage NTSB CHI72FEV03Accident · No injuriesClosedStits SA3A · Macomb, ILJul 17, 1971 · N74872 · Substantial damage NTSB CHI72FEE05Accident · No injuriesClosedCessna 182 · Lansing, ILJul 17, 1971 · N6237A · Substantial damage NTSB CHI72AC007Accident · 2 fatalClosedCessna 170A · Pittsfield, ILJul 16, 1971 · N1499D · Destroyed NTSB CHI72FEE03Accident · No injuriesClosedBeech 65-90 · Rockford, ILJul 14, 1971 · N721K · Substantial damage NTSB CHI72FEE07Accident · No injuriesClosedBreezie B1 · Loves Park, ILJul 13, 1971 · N429RT · Substantial damage NTSB CHI71FEE02Accident · No injuriesClosedRotorway Scorpn · Sugar Grove, ILJul 11, 1971 · N10DW · Substantial damage NTSB CHI72FEE06Accident · No injuriesClosedBeech B35 · Hinsdale, ILJul 9, 1971 · N5205C · Substantial damage NTSB CHI72FEE04Accident · Minor injuriesClosedCessna 150L · Deerfield, ILJul 7, 1971 · N6926G · Substantial damage NTSB CHI72FEV02Accident · No injuriesClosedGrumman G-164A · Arthur, ILJul 5, 1971 · N7847 · Destroyed NTSB CHI72AC003Accident · 5 fatalClosedPiper PA-24 · Philo, ILJul 4, 1971 · N9120P · Destroyed NTSB CHI72AC002Accident · 1 fatalClosedRyan ST-3KR · Valmeyer, ILJul 3, 1971 · N73729 · Destroyed NTSB CHI71DEE01Accident · No injuriesClosedBeech A23-19 · Joliet, ILJul 3, 1971 · N7643R · Substantial damage