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 CHI66F0462Accident · No injuriesClosedCessna 310 · Chicago, ILDec 4, 1965 · N4890B · Substantial damage NTSB CHI66F0506Accident · No injuriesClosedCessna 172 · Moline, ILDec 3, 1965 · N5766T · Substantial damage NTSB CHI66D0440Accident · No injuriesClosedLuscombe 8E · Collinsville, ILNov 27, 1965 · N1573B · Substantial damage NTSB CHI66I0052Incident · No injuriesClosedDouglas DC-8 · Chicago, ILNov 23, 1965 · N811E · Minor damage NTSB CHI66F0478Accident · No injuriesClosedPiper PA-23 · East St Louis, ILNov 22, 1965 · N3205P · Substantial damage NTSB CHI66A0051Accident · 4 fatalClosedCessna 172F · Chicago Hgts, ILNov 21, 1965 · N5582R · Destroyed NTSB CHI66F0463Accident · No injuriesClosedCessna 310J · Northbrook, ILNov 20, 1965 · N3108L · Substantial damage NTSB CHI66A0050Accident · No injuriesClosedCessna 310D · Peoria, ILNov 19, 1965 · N6777T · Substantial damage NTSB CHI66D0464Accident · No injuriesClosedBeechcraft 95-55 · Des Plaines, ILNov 18, 1965 · N7970K · Substantial damage NTSB CHI66D0417Accident · No injuriesClosedPiper J-3 · Half Day, ILNov 11, 1965 · N98608 · Substantial damage NTSB CHI66F0470Accident · No injuriesClosedMooney M20E · Sullivan, ILNov 7, 1965 · N5721Q · Substantial damage NTSB CHI66D0409Accident · No injuriesClosedBeechcraft 35-C33 · Wheeling, ILNov 3, 1965 · N8928U · Substantial damage NTSB CHI66F0398Accident · No injuriesClosedPiper PA-22 · Shelbyville, ILNov 2, 1965 · N5430Z · Substantial damage NTSB CHI66F0437Accident · No injuriesClosedCessna 182A · Effingham, ILOct 23, 1965 · N3833D · Substantial damage NTSB CHI66A0040Accident · No injuriesClosedBell 47H1 · Niles, ILOct 19, 1965 · N8696E · Destroyed NTSB CHI66F0349Accident · No injuriesClosedCessna 150F · Scott Afb, ILOct 17, 1965 · N8279S · Substantial damage NTSB CHI66D0390Accident · No injuriesClosedPiper PA-28 · Lombard, ILOct 17, 1965 · N6762W · Substantial damage NTSB CHI66F0360Accident · Serious injuriesClosedCessna 172F · Chicago, ILOct 10, 1965 · N8540U · Destroyed NTSB CHI66D0643Accident · No injuriesClosedCessna 180 · Aurora, ILOct 10, 1965 · N3179D · Substantial damage NTSB CHI66F0382Accident · 1 fatalClosedPiper PA-22 · Coffeen, ILOct 6, 1965 · N9238D · Substantial damage NTSB CHI66F0359Accident · No injuriesClosedFairchild 24G · Joliet, ILOct 3, 1965 · N16900 · Substantial damage NTSB CHI66D0323Accident · No injuriesClosedMooney M20D · Downers Grove, ILSep 26, 1965 · N6828U · Substantial damage NTSB CHI66F0324Accident · No injuriesClosedCessna 320C · Chicago, ILSep 24, 1965 · N3005T · Substantial damage NTSB CHI66A0029Accident · No injuriesClosedAir & Space 18A · Vandalia, ILSep 24, 1965 · N6121 · Substantial damage NTSB CHI66F0327Accident · No injuriesClosedNavion G · Peoria, ILSep 23, 1965 · N2424T · Substantial damage NTSB CHI66F0310Accident · Minor injuriesClosedTaylorcraft BC-12D · Stauton, ILSep 11, 1965 · N43946 · Substantial damage NTSB CHI66D0357Accident · No injuriesClosedCessna 180 · Pontiac, ILSep 9, 1965 · N9181C · Substantial damage NTSB CHI66D0317Accident · No injuriesClosedCessna 182E · Chicago, ILSep 9, 1965 · N2865Y · Substantial damage NTSB CHI66F0217Accident · No injuriesClosedPiper PA-22 · Lacon, ILSep 8, 1965 · N9971D · Substantial damage NTSB CHI66F0219Accident · No injuriesClosedCessna 120 · Sparta, ILSep 5, 1965 · N4075N · Substantial damage NTSB CHI66F0306Accident · Serious injuriesClosedCessna 195A · Frankfort, ILSep 4, 1965 · N1052D · Destroyed NTSB CHI66F0226Accident · No injuriesClosedPiper PA-24 · Joliet, ILSep 4, 1965 · N7833P · Substantial damage NTSB CHI66D0199Accident · No injuriesClosedCessna 172 · Rockford, ILSep 2, 1965 · N8654U · Substantial damage NTSB CHI66F0386Accident · No injuriesClosedCessna 170B · Half Day, ILAug 29, 1965 · N4550C · Substantial damage NTSB CHI66F0314Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 29, 1965 · N4429U · 2 aircraft · Substantial damage NTSB CHI66D0334Accident · No injuriesClosedCessna 172 · Jerseyville, ILAug 29, 1965 · N5673T · Substantial damage NTSB CHI66F0307Accident · No injuriesClosedPiper PA-22 · Lombard, ILAug 28, 1965 · N4957E · Substantial damage NTSB CHI66D0195Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 24, 1965 · N6130T · Substantial damage NTSB CHI66F0204Accident · No injuriesClosedCessna 172 · Nokomis, ILAug 23, 1965 · N6421E · Substantial damage NTSB CHI66F0227Accident · No injuriesClosedStinson 108-1 · Wilmington, ILAug 22, 1965 · N8982K · Substantial damage NTSB CHI66A0018Accident · 1 fatalClosedCessna 170A · Metropolis, ILAug 19, 1965 · N9501A · Destroyed NTSB CHI66F0209Accident · No injuriesClosedCessna 140 · Trivoli, ILAug 17, 1965 · N4158N · Substantial damage NTSB CHI66F0202Accident · No injuriesClosedCessna 310 · Wheeling, ILAug 17, 1965 · N198R · Substantial damage NTSB DCA66A0002Accident · 30 fatalClosedBoeing B-727 · Lake Michigan, ILAug 16, 1965 · N7036U · Destroyed NTSB CHI66D0158Accident · No injuriesClosedPiper J-3 · Wheeling, ILAug 16, 1965 · N42426 · Substantial damage NTSB CHI66A0017Accident · No injuriesClosedNaa B-25J · Northbrook, ILAug 16, 1965 · N75755 · Substantial damage NTSB CHI66F0508Accident · No injuriesClosedGlobe GC-1B · Marissa, ILAug 15, 1965 · N78181 · Substantial damage NTSB CHI66F0211Accident · Minor injuriesClosedLuscombe 8E · Plainfield, ILAug 15, 1965 · N71911 · Substantial damage NTSB CHI66F0180Accident · No injuriesClosedBeechcraft 95 · Quincy, ILAug 14, 1965 · N2733Y · Substantial damage NTSB CHI66F0166Accident · No injuriesClosedCessna 180 · Avon, ILAug 14, 1965 · N9440C · Substantial damage