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 CHI72FEE65Accident · Minor injuriesClosedBeech 35 · Ringwood, ILFeb 27, 1972 · N5050E · Substantial damage NTSB CHI72FEE58Accident · No injuriesClosedCessna 150 · Northbrook, ILFeb 26, 1972 · N22265 · 2 aircraft · Substantial damage NTSB CHI72FEV23Accident · No injuriesClosedCessna 310D · Pinckneyville, ILFeb 17, 1972 · N320G · Substantial damage NTSB CHI72DEE57Accident · No injuriesClosedBowers Baby · Plainfield, ILFeb 12, 1972 · N6314 · Substantial damage NTSB CHI72DEE63Accident · No injuriesClosedCessna 172I · Kirkland, ILFeb 3, 1972 · N46194 · Substantial damage NTSB CHI72FEV22Accident · Serious injuriesClosedPiper PA-23 · Springfield, ILJan 29, 1972 · N6567F · Substantial damage NTSB MKC72DCA21Accident · No injuriesClosedCessna 172 · Cahokia, ILJan 24, 1972 · N7710U · Substantial damage NTSB CHI72FEE56Accident · Minor injuriesClosedCessna P206 · Chicago, ILJan 21, 1972 · N2568X · Substantial damage NTSB CHI72AC061Accident · 1 fatalClosedPiper PA-23 · St.Charles, ILJan 21, 1972 · N4029P · Destroyed NTSB CHI72AC059Accident · 1 fatalClosedMooney M20E · Northbrook, ILJan 19, 1972 · N9458V · Destroyed NTSB CHI72FEV21Accident · No injuriesClosedPiper PA-30 · Effingham, ILJan 17, 1972 · N7216Y · Substantial damage NTSB CHI72DEE61Accident · No injuriesClosedCessna 182 · Chicago, ILJan 17, 1972 · N70638 · Substantial damage NTSB CHI72DEE55Accident · No injuriesClosedCessna 310L · Moline, ILJan 15, 1972 · N3331X · Substantial damage NTSB CHI72DEE53Accident · No injuriesClosedPiper PA-28 · Beecher, ILJan 11, 1972 · N537FL · Substantial damage NTSB CHI72FEE50Accident · No injuriesClosedBellanca 17-30 · Crystal Lake, ILJan 8, 1972 · N6564V · Substantial damage NTSB CHI72FEE49Accident · No injuriesClosedBellanca 17-30 · Joliet, ILJan 8, 1972 · N8777V · Substantial damage NTSB CHI72DEE54Accident · No injuriesClosedBell 206 · Polo, ILJan 8, 1972 · N14EL · Substantial damage NTSB CHI72DEE52Accident · No injuriesClosedCessna 172L · Lockport, ILJan 8, 1972 · N7885G · Substantial damage NTSB CHI72FEV19Accident · No injuriesClosedBeech 23 · Iroquois, ILJan 4, 1972 · N2354J · Substantial damage NTSB CHI72DEV20Accident · No injuriesClosedTaylorcraft BC12-D · Jacksonville, ILDec 31, 1971 · N95057 · Substantial damage NTSB CHI72AC056Accident · 2 fatalClosedPiper PA-24 · Rockford, ILDec 30, 1971 · N5518P · Destroyed NTSB CHI72IC055Incident · 1 fatalClosedLockheed Ga 382 · Chicago, ILDec 26, 1971 · N9258R · No damage NTSB CHI72FEE51Accident · No injuriesClosedBeech 18 · Chicago, ILDec 24, 1971 · N588K · Substantial damage NTSB CHI72AC051Accident · 2 fatalClosedCessna 320D · Springfield, ILDec 12, 1971 · N777K · Destroyed NTSB CHI72FEE48Accident · No injuriesClosedNavion B · Harvard, ILDec 11, 1971 · N5327K · Substantial damage NTSB CHI72FEE46Accident · No injuriesClosedCessna 150L · Libertyville, ILNov 30, 1971 · N6835G · Substantial damage NTSB CHI72FEE47Accident · No injuriesClosedPiper PA-12 · Elgin, ILNov 27, 1971 · N3847M · Substantial damage NTSB CHI72DEV18Accident · No injuriesClosedPiper PA-16 · Lawrenceville, ILNov 20, 1971 · N5899H · Substantial damage NTSB CHI72DEE45Accident · No injuriesClosedMooney M20B · Rockford, ILNov 13, 1971 · N74578 · Substantial damage NTSB CHI72FEE43Accident · No injuriesClosedCessna 310H · Elgin, ILNov 7, 1971 · N7171L · Destroyed NTSB CHI72DEE39Accident · No injuriesClosedPiper PA-23 · Streator, ILNov 2, 1971 · N5511Y · Substantial damage NTSB CHI72DEE44Accident · No injuriesClosedPiper PA-32 · Rockford, ILOct 30, 1971 · N757UG · Substantial damage NTSB CHI72FEE42Accident · No injuriesClosedBeech V35A · Kankakee, ILOct 29, 1971 · N7935R · Substantial damage NTSB DCA72AZ004Accident · 16 fatalClosedBeech E18S · Peoria, ILOct 21, 1971 · N51CS · Destroyed NTSB CHI72DEE40Accident · No injuriesClosedCessna 170B · Moline, ILOct 21, 1971 · N3532C · Substantial damage NTSB CHI72FEE41Accident · No injuriesClosedCessna 150 · Seneca, ILOct 20, 1971 · N5696G · Substantial damage NTSB CHI72DEE38Accident · No injuriesClosedCessna 150 · Sandwich, ILOct 18, 1971 · N5944G · Substantial damage NTSB CHI72DEV17Accident · No injuriesClosedPiper PA-25 · Ware, ILOct 15, 1971 · N4552Y · Substantial damage NTSB CHI72FEV16Accident · No injuriesClosedPiper PA-28 · Carlinville, ILOct 14, 1971 · N5889W · Substantial damage NTSB CHI72FEE35Accident · No injuriesClosedPiper PA-24 · Rockford, ILOct 12, 1971 · N8702P · Substantial damage NTSB CHI72FEE32Accident · No injuriesClosedBeech 95-B55 · Lockport, ILOct 9, 1971 · N7515N · Substantial damage NTSB CHI72AC034Accident · No injuriesClosedDouglas DC-9 · Chicago, ILOct 9, 1971 · N3308L · Minor damage NTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILOct 9, 1971 · N6597W · 2 aircraft · Substantial damage NTSB CHI72FEE37Accident · No injuriesClosedCessna 150 · Chicago, ILOct 6, 1971 · N8405M · Destroyed NTSB CHI72FEE29Accident · No injuriesClosedKnight OW-1 · Maple Park, ILOct 4, 1971 · N1013Z · Substantial damage NTSB CHI72FEE30Accident · Serious injuriesClosedPiper PA-12 · Gardner, ILOct 3, 1971 · N3445M · Destroyed NTSB CHI72FCA01Accident · No injuriesClosedPiper PA-24 · E St Louis, ILOct 3, 1971 · N6886P · Substantial damage NTSB CHI72FEE33Accident · No injuriesClosedMooney M20E · Caledonia, ILOct 2, 1971 · N5979Q · Substantial damage NTSB CHI72FEE31Accident · No injuriesClosedPiper PA-22 · Mchenry, ILSep 29, 1971 · N4660Z · Destroyed NTSB CHI72AC029Accident · 4 fatalClosedCessna 177 · Hanna City, ILSep 27, 1971 · N3417T · Substantial damage