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 CHI70FBQ14Accident · Minor injuriesClosedCessna 150B · Oakley, ILMay 2, 1970 · N7332X · Substantial damage NTSB CHI70FBD30Accident · No injuriesClosedPiper PA-28 · Ottawa, ILMay 2, 1970 · N6358W · Substantial damage NTSB CHI70DBD32Accident · No injuriesClosedWitman T-WIND · Mt.Carroll, ILMay 2, 1970 · N1731 · Substantial damage NTSB CHI70FBD29Accident · Minor injuriesClosedBeech 35 · Richmond, ILMay 1, 1970 · N2975V · Substantial damage NTSB CHI70DBD26Accident · No injuriesClosedCessna 150G · Naperville, ILApr 29, 1970 · N3045S · Substantial damage NTSB CHI70AC074Accident · 2 fatalClosedCessna 336 · Chicago, ILApr 28, 1970 · N3815U · Destroyed NTSB CHI70FBD28Accident · 1 fatalClosedJohnson Cassut · Orland Park, ILApr 26, 1970 · N4486 · Destroyed NTSB CHI70DBD25Accident · No injuriesClosedBeech 35 · Moline, ILApr 24, 1970 · N2792V · Substantial damage NTSB CHI71DBD53Accident · No injuriesClosedLuscombe 8A · Cary, ILApr 23, 1970 · N71711 · Substantial damage NTSB CHI70FBQ11Accident · No injuriesClosedCessna 182M · Springfield, ILApr 21, 1970 · N71114 · Substantial damage NTSB CHI70FBD24Accident · No injuriesClosedBeech C-45H · Rockford, ILApr 20, 1970 · N256RA · Substantial damage NTSB CHI70FBD27Accident · Serious injuriesClosedDehavilland 104-6A · Morris, ILApr 16, 1970 · N420D · Destroyed NTSB CHI70DBD23Accident · No injuriesClosedBeech A23-19 · Waukegan, ILApr 7, 1970 · N6060N · Substantial damage NTSB CHI70FBQ10Accident · No injuriesClosedCessna 150 · Galesburg, ILApr 4, 1970 · N8631S · Substantial damage NTSB CHI70FBD22Accident · No injuriesClosedPiper PA-30 · Dixon, ILApr 3, 1970 · N7875Y · Substantial damage NTSB CHI70DBD44Accident · No injuriesClosedPiper PA-28 · Lansing, ILApr 3, 1970 · N7346J · Substantial damage NTSB CHI70IC067Incident · No injuriesClosedBoeing 707 · Chicago, ILMar 28, 1970 · N7591A · No damage NTSB CHI70FBQ09Accident · No injuriesClosedPiper PA-28 · Blooming, ILMar 28, 1970 · N5233L · Substantial damage NTSB CHI70AC060Accident · 1 fatalClosedBeech 65-A80 · Wheeling, ILMar 25, 1970 · N242U · Destroyed NTSB CHI70FBD21Accident · No injuriesClosedBeech 35 · West Chicago, ILMar 21, 1970 · N3776N · Substantial damage NTSB CHI70AC064Accident · 2 fatalClosedCessna 150J · Brighton, ILMar 21, 1970 · N61034 · Destroyed NTSB CHI70AC062Accident · No injuriesClosedPiper PA-32 · Northbrook, ILMar 14, 1970 · N3271W · Substantial damage NTSB CHI70FBQ08Accident · No injuriesClosedPiper PA-28 · Paris, ILMar 8, 1970 · N8199N · Substantial damage NTSB CHI70DBD20Accident · No injuriesClosedPiper PA-28 · Northbrook, ILMar 7, 1970 · N8041N · Substantial damage NTSB CHI70AC059Accident · Serious injuriesClosedBoeing 720 · Chicago, ILMar 2, 1970 · N7210U · No damage NTSB CHI70FBQ07Accident · No injuriesClosedCessna 182L · Mount Olive, ILFeb 21, 1970 · N42064 · Substantial damage NTSB CHI70DBD19Accident · No injuriesClosedBeech 35-B33 · Grayslake, ILFeb 21, 1970 · N8962M · Substantial damage NTSB CHI70DBD17Accident · No injuriesClosedLockheed Ga 1329 · Desplaines, ILFeb 16, 1970 · N1207Z · Substantial damage NTSB CHI70AC053Accident · 2 fatalClosedCessna 150G · Rantoul, ILFeb 16, 1970 · N2968J · Destroyed NTSB CHI70FBQ06Accident · No injuriesClosedCessna 150F · Mt Hawley, ILFeb 14, 1970 · N8700S · Substantial damage NTSB CHI70DBD18Accident · No injuriesClosedLil Honey H0-1 · Monee, ILFeb 14, 1970 · N4943E · Substantial damage NTSB CHI70FBQ04Accident · No injuriesClosedPiper PA-23 · Peoria, ILFeb 2, 1970 · N5855Y · Substantial damage NTSB CHI70FBD13Accident · Minor injuriesClosedCessna 205 · Stockton, ILFeb 1, 1970 · N1828Z · Substantial damage NTSB CHI70DBD16Accident · No injuriesClosedPiper PA-28 · Kewanee, ILJan 27, 1970 · N6671J · Substantial damage NTSB CHI70DBD11Accident · No injuriesClosedPiper PA-22 · Loves Park, ILJan 27, 1970 · N5679Z · Substantial damage NTSB CHI70DBD14Accident · No injuriesClosedPiper PA-32 · Wheeling, ILJan 25, 1970 · N3478W · Substantial damage NTSB CHI70DBD15Accident · No injuriesClosedRyan ST-3KR · Stockton, ILJan 24, 1970 · N60170 · Substantial damage NTSB CHI70FBQ03Accident · No injuriesClosedCessna 150J · Chillicothe, ILJan 22, 1970 · N6112G · Substantial damage NTSB CHI70FBQ02Accident · No injuriesClosedBeech D18S · Springfield, ILJan 21, 1970 · N279AG · Substantial damage NTSB CHI70DBD10Accident · No injuriesClosedPiper PA-24 · Naperville, ILJan 20, 1970 · N8303P · Substantial damage NTSB CHI70DBD08Accident · No injuriesClosedPiper PA-28R · Hinsdale, ILJan 20, 1970 · N7423J · Substantial damage NTSB CHI70DBD07Accident · No injuriesClosedCessna 172 · Morris, ILJan 17, 1970 · N78491 · Substantial damage NTSB CHI70DBD12Accident · No injuriesClosedCessna 175 · Ringwood, ILJan 13, 1970 · N7148M · Substantial damage NTSB CHI70DBD06Accident · No injuriesClosedCessna 150 · Roselle, ILJan 11, 1970 · N6227S · Substantial damage NTSB CHI70DBD04Accident · No injuriesClosedAeronca 11AC · Sycamore, ILJan 11, 1970 · N9453E · Substantial damage NTSB CHI70DBD03Accident · No injuriesClosedCessna 150 · Wheeling, ILJan 10, 1970 · N3076S · Substantial damage NTSB CHI70ABD05Accident · No injuriesClosedCessna 150 · Rockford, ILJan 10, 1970 · N7860F · Substantial damage NTSB CHI70DBD09Accident · No injuriesClosedCessna 150G · Wauconda, ILJan 5, 1970 · N3135J · Substantial damage NTSB CHI70DBQ01Accident · No injuriesClosedCessna 182 · Lawrenceville, ILJan 4, 1970 · N2309R · Substantial damage NTSB CHI70DBD02Accident · Minor injuriesClosedCessna 182A · Sycamore, ILJan 4, 1970 · N5199D · Substantial damage