Skip to content

NTSB investigations, IN

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CHI66F0523Accident · No injuriesClosedBeechcraft 35B33 · Elkhart, INJan 15, 1966 · N8948M · Substantial damage NTSB CHI66D0524Accident · No injuriesClosedCessna 150 · Terre Haute, INJan 14, 1966 · N8534G · Substantial damage NTSB CHI66F0515Accident · No injuriesClosedPiper PA-30 · Franklin, INJan 6, 1966 · N7073Y · Substantial damage NTSB CHI66D0512Accident · No injuriesClosedPiper PA-23 · Franklin, INJan 6, 1966 · N5025Y · Substantial damage NTSB CHI66F0501Accident · No injuriesClosedPiper PA-24 · Wabash, INDec 26, 1965 · N5242P · Substantial damage NTSB CHI66F0475Accident · No injuriesClosedPiper PA-23 · Muncie, INDec 26, 1965 · N5655Y · Substantial damage NTSB CHI66F0500Accident · No injuriesClosedMooney M-20E · Indianapolis, INDec 25, 1965 · N59240 · Substantial damage NTSB CHI66F0492Accident · No injuriesClosedBeechcraft N35 · Mishawaka, INDec 19, 1965 · N1241Z · Substantial damage NTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · Destroyed NTSB CHI66D0504Accident · No injuriesClosedPiper PA-24 · Indianapolis, INDec 18, 1965 · N8451P · Substantial damage NTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INDec 10, 1965 · N8072S · Destroyed NTSB CHI66D0473Accident · No injuriesClosedMooney M20B · Indianapolis, INDec 5, 1965 · N7890Z · Substantial damage NTSB CHI66A0054Accident · No injuriesClosedBell 47G-4 · Indianapolis, INNov 29, 1965 · N8507F · Substantial damage NTSB CHI66D0487Accident · No injuriesClosedCessna 175 · Syracuse, INNov 26, 1965 · N6558E · Substantial damage NTSB CHI66D0484Accident · No injuriesClosedPiper PA-28 · Auburn, INNov 17, 1965 · N6764W · Substantial damage NTSB CHI66F0433Accident · No injuriesClosedCessna 182 · South Bend, INNov 7, 1965 · N3458S · Substantial damage NTSB CHI66F0413Accident · Minor injuriesClosedPiper J3C-65 · Greenfield, INNov 7, 1965 · N87851 · Substantial damage NTSB CHI66F0405Accident · No injuriesClosedLuscombe 8A · Kempton, INNov 7, 1965 · N77826 · Substantial damage NTSB CHI66F0399Accident · Minor injuriesClosedPiper PA-16 · Ladoga, INNov 7, 1965 · N5634H · Substantial damage NTSB CHI66F0378Accident · No injuriesClosedPiper PA-30 · Muncie, INNov 7, 1965 · N7807Y · Substantial damage NTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNov 1, 1965 · N7227T · 2 aircraft · Substantial damage NTSB CHI66F0418Accident · No injuriesClosedBeechcraft D18S · Valparaiso, INOct 31, 1965 · N5882C · Substantial damage NTSB CHI66F0407Accident · 1 fatalClosedSchweizer SGS126 · Ramsey, INOct 31, 1965 · N8633R · Substantial damage NTSB CHI66D0439Accident · No injuriesClosedPiper PA-28 · Franklin, INOct 22, 1965 · N6104W · Substantial damage NTSB CHI66D0456Accident · No injuriesClosedBeechcraft D-18S · Ft Wayne, INOct 21, 1965 · N935TX · Substantial damage NTSB CHI66A0044Accident · 1 fatalClosedCessna 172 · Liberty, INOct 21, 1965 · N2736A · Destroyed NTSB CHI66D0432Accident · No injuriesClosedPiper PA-20 · Ft Wayne, INOct 19, 1965 · N7667K · Substantial damage NTSB CHI66F0619Accident · No injuriesClosedBeechcraft 23 · Fort Wayne, INOct 18, 1965 · N2381Z · Substantial damage NTSB CHI66F0400Accident · Serious injuriesClosedPiper PA-28 · Portage, INOct 17, 1965 · N5964Z · Destroyed NTSB CHI66D0379Accident · No injuriesClosedCessna 172 · Greenwood, INOct 17, 1965 · N6105E · Substantial damage NTSB CHI66A0037Accident · 2 fatalClosedNavion A · Spencer, INOct 17, 1965 · N4954K · Destroyed NTSB CHI66F0434Accident · No injuriesClosedAero Cmdr 560-A · Valparaiso, INOct 12, 1965 · N2764B · Substantial damage NTSB CHI66A0032Accident · 1 fatalClosedAir Space 18A · Muncie, INOct 7, 1965 · N6138S · Destroyed NTSB CHI66F0381Accident · No injuriesClosedPiper PA-12 · Rensselaer, INSep 25, 1965 · N7743H · Substantial damage NTSB CHI66D0319Accident · No injuriesClosedCessna 150 · Crawfordsville, INSep 24, 1965 · N1160Y · Substantial damage NTSB CHI66D0438Accident · Minor injuriesClosedTaylorcraft BC12-D · Cedar Grove, INSep 23, 1965 · N5182M · Substantial damage NTSB CHI66F0351Accident · No injuriesClosedCessna 172 · Roselawn, INSep 19, 1965 · N5533R · Substantial damage NTSB CHI66F0318Accident · No injuriesClosedPiper PA-30 · Madison, INSep 17, 1965 · N70594 · Substantial damage NTSB CHI66A0027Accident · Serious injuriesClosedAir Space 18A · Hobart, INSep 15, 1965 · N6114S · Substantial damage NTSB CHI66D0312Accident · No injuriesClosedCessna 172 · Nft Wayne, INSep 14, 1965 · N5708R · Substantial damage NTSB CHI66F0308Accident · No injuriesClosedBeechcraft C-18S · Jamestown, INSep 8, 1965 · N4723C · Substantial damage NTSB CHI66D0198Accident · No injuriesClosedAero Cmdr 680F · Indianapolis, INSep 7, 1965 · N6144X · Substantial damage NTSB CHI66F0313Accident · No injuriesClosedPiper PA-22 · Clermont, INSep 6, 1965 · N8502C · Substantial damage NTSB CHI66F0338Accident · Minor injuriesClosedBeechcraft D-17S · Evansville, INSep 2, 1965 · N67426 · Substantial damage NTSB CHI66F0385Accident · No injuriesClosedPiper PA-28 · Kendallville, INAug 29, 1965 · N5831W · Substantial damage NTSB CHI66F0221Accident · Serious injuriesClosedBeech H35 · Dunkirk, INAug 29, 1965 · N7918D · Substantial damage NTSB CHI66D0228Accident · No injuriesClosedPiper PA-28 · Chesterton, INAug 25, 1965 · N8606W · Substantial damage NTSB CHI66A0020Accident · No injuriesClosedBrantly B2 · Williamsport, INAug 24, 1965 · CFNGR · Substantial damage NTSB CHI66F0185Accident · No injuriesClosedPiper PA-28 · Culver, INAug 18, 1965 · N9060W · Substantial damage NTSB CHI66D0192Accident · No injuriesClosedCessna 172 · Milan, INAug 17, 1965 · N8207X · Substantial damage