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 CHI68F0546Accident · Minor injuriesClosedCessna 411A · Elkhart, INJan 10, 1968 · N3254R · Substantial damage NTSB CHI68D0532Accident · No injuriesClosedCessna 150 · Vincennes, INJan 7, 1968 · N379VU · Substantial damage NTSB CHI68D0520Accident · No injuriesClosedPiper PA-28 · Marion, INJan 7, 1968 · N9080J · Substantial damage NTSB CHI68F0519Accident · Minor injuriesClosedCessna 182 · Greencastle, INDec 27, 1967 · N5081D · Destroyed NTSB CHI68A0056Accident · 3 fatalClosedMooney M20F · Knox, INDec 22, 1967 · N2779W · Destroyed NTSB CHI68D0510Accident · No injuriesClosedCessna 172 · Greenwood, INDec 20, 1967 · N4033F · Substantial damage NTSB CHI68D0521Accident · No injuriesClosedLuscombe 8E · Richmond, INDec 19, 1967 · N2632K · Substantial damage NTSB CHI68A0052Accident · 2 fatalClosedHughes 269B · Evansville, INDec 9, 1967 · N9454F · Destroyed NTSB CHI68F0493Accident · No injuriesClosedBeech M35 · Pierceton, INDec 4, 1967 · N9329Y · Destroyed NTSB CHI68D0474Accident · No injuriesClosedCessna 150E · Indianapolis, INNov 28, 1967 · N4063U · No damage NTSB CHI68F0438Accident · No injuriesClosedPiper PA-22 · Indianapolis, INNov 23, 1967 · N9600D · Substantial damage NTSB CHI68I0454Accident · No injuriesClosedBeech 35 · Griffith, INNov 14, 1967 · N4555V · Substantial damage NTSB CHI67F0460Accident · No injuriesClosedAero Comdr 500 · Ft Wayne, INNov 8, 1967 · N135M · Substantial damage NTSB CHI68A0044Accident · 1 fatalClosedPiper PA-25 · Sullivan, INNov 7, 1967 · N9100D · Destroyed NTSB CHI68F0430Accident · No injuriesClosedCessna 320E · Valparaiso, INNov 4, 1967 · N3430Q · Substantial damage NTSB CHI68A0042Accident · 3 fatalClosedBrantly 305 · Taswell, INNov 3, 1967 · N2208U · Destroyed NTSB CHI68D0399Accident · No injuriesClosedPiper PA-22 · English, INOct 30, 1967 · N5797Z · Destroyed NTSB CHI68D0372Accident · No injuriesClosedCessna 150 · Indianapolis, INOct 23, 1967 · N3764J · Substantial damage NTSB CHI68F0426Accident · No injuriesClosedBeech G35 · Indianapolis, INOct 21, 1967 · N4222D · Substantial damage NTSB CHI68F0441Accident · Minor injuriesClosedCessna 337 · South Bend, INOct 18, 1967 · N6324F · Substantial damage NTSB CHI68F0425Accident · No injuriesClosedCessna 172 · Salem, INOct 14, 1967 · N4140F · Substantial damage NTSB CHI68F0394Accident · No injuriesClosedCessna 310 · South Bend, INOct 14, 1967 · N6777T · Substantial damage NTSB CHI68D0407Accident · No injuriesClosedCessna 182 · South Bend, INOct 14, 1967 · N3079Q · Substantial damage NTSB CHI68F0350Accident · No injuriesClosedBeech A23 · Woodburn, INOct 8, 1967 · N1423L · Substantial damage NTSB CHI68F0429Accident · No injuriesClosedCessna 210 · Indianapolis, INOct 5, 1967 · N9590X · Substantial damage NTSB CHI68F0395Accident · No injuriesClosedPiper PA-28 · Knox, INOct 2, 1967 · N7946W · Substantial damage NTSB CHI68D0382Accident · No injuriesClosedNavion F · Hartford City, INOct 1, 1967 · N238 · Substantial damage NTSB CHI68D0365Accident · No injuriesClosedPiper PA-28 · Muncie, INOct 1, 1967 · N9770W · Substantial damage NTSB CHI68D0349Accident · No injuriesClosedPiper PA-16 · Noblesville, INOct 1, 1967 · N5224H · Substantial damage NTSB CHI68F0378Accident · No injuriesClosedNavion F · Crawfordsvlle, INSep 30, 1967 · N91774 · Substantial damage NTSB CHI68D0405Accident · No injuriesClosedStinson V-77 · Lebanon, INSep 30, 1967 · N69874 · Substantial damage NTSB CHI68A0032Accident · No injuriesClosedCessna 310L · Plymouth, INSep 27, 1967 · N3282X · Substantial damage NTSB CHI68F0338Accident · No injuriesClosedCessna 150 · Fort Wayne, INSep 25, 1967 · N8394G · Substantial damage NTSB CHI68F0578Accident · No injuriesClosedGlobe Swift GC-1B · W Lafayette, INSep 24, 1967 · N80792 · Substantial damage NTSB CHI68F0328Accident · No injuriesClosedPiper PA-22 · Wabash, INSep 24, 1967 · N6999B · Substantial damage NTSB CHI68F0337Accident · No injuriesClosedLuscombe 8A · Muncie, INSep 23, 1967 · N2136K · Substantial damage NTSB CHI68D0485Accident · No injuriesClosedPiper PA-22 · Greenwood, INSep 23, 1967 · N3656P · Substantial damage NTSB CHI68D0359Accident · No injuriesClosedBeech 95 · Clermont, INSep 23, 1967 · N659T · Substantial damage NTSB CHI68F0304Accident · No injuriesClosedCessna 320E · Indianapolis, INSep 17, 1967 · N394AJ · Substantial damage NTSB CHI68F0428Accident · No injuriesClosedCessna 210 · Evansville, INSep 16, 1967 · N9658T · Substantial damage NTSB CHI68F0352Accident · Minor injuriesClosedPiper PA-22 · Jamestown, INSep 10, 1967 · N8711D · Substantial damage NTSB CHI68F0336Accident · Serious injuriesClosedPiper PA-22 · Greenfield, INSep 10, 1967 · N3740P · 2 aircraft · Substantial damage NTSB CHI68A0024Accident · 2 fatalClosedPiper PA-30 · Crawfordsvle, INSep 6, 1967 · N8411Y · Destroyed NTSB CHI68D0250Accident · No injuriesClosedLuscombe 8A · Richmond, INSep 5, 1967 · N77841 · Substantial damage NTSB CHI68F0308Accident · No injuriesClosedTaylorcraft BC12-D · Chesterton, INSep 3, 1967 · N36047 · Substantial damage NTSB CHI68D0348Accident · No injuriesClosedCessna 140 · Brownsburg, INSep 3, 1967 · N2848N · Substantial damage NTSB CHI68F0229Accident · No injuriesClosedN.American P-51D · Auburn, INSep 2, 1967 · N6836C · Substantial damage NTSB CHI68D0281Accident · Minor injuriesClosedCessna 205 · Princeton, INAug 26, 1967 · N8150Z · Substantial damage NTSB CHI68F0300Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INAug 23, 1967 · N8247W · Substantial damage NTSB CHI68F0182Accident · No injuriesClosedBeech A35 · Mishawaka, INAug 17, 1967 · N8643A · Substantial damage