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 CHI70F0192Accident · Serious injuriesClosedCessna 150 · Plymouth, INJun 28, 1969 · N3451J · Destroyed NTSB CHI70D0123Accident · No injuriesClosedCallair A-9 · Hobart, INJun 28, 1969 · N3603G · Substantial damage NTSB CHI70F0058Accident · No injuriesClosedLuscombe 8E · Southport, INJun 17, 1969 · N39013 · Substantial damage NTSB CHI70F0069Accident · No injuriesClosedPlaymate II · Angola, INJun 12, 1969 · N1093Z · Substantial damage NTSB CHI70F0118Accident · Minor injuriesClosedPiper PA-30 · Gary, INJun 9, 1969 · N7492Y · Destroyed NTSB CHI70D0141Accident · No injuriesClosedPiper J-3 · Mentone, INJun 7, 1969 · N24643 · Substantial damage NTSB CHI70D0082Accident · No injuriesClosedPiper J-3 · Richmond, INMay 31, 1969 · N70430 · No damage NTSB CHI70D0044Accident · No injuriesClosedCessna 172H · Hobart, INMay 30, 1969 · N8260L · Substantial damage NTSB CHI70D0039Accident · No injuriesClosedCessna 182 · Lafayette, INMay 30, 1969 · N3143Q · Substantial damage NTSB CHI70F0027Accident · No injuriesClosedBeech B23 · Indianapolis, INMay 28, 1969 · N6989Q · Substantial damage NTSB CHI69F0667Accident · Serious injuriesClosedCessna 150H · Indian Sprgs, INMay 27, 1969 · N50153 · Destroyed NTSB CHI70D0006Accident · No injuriesClosedCessna 172 · Shelby, INMay 17, 1969 · N35672 · Substantial damage NTSB CHI70D0076Accident · No injuriesClosedPiper PA-22 · Rockville, INMay 16, 1969 · N673A · Substantial damage NTSB CHI70D0024Accident · Minor injuriesClosedCessna 177 · Indianapolis, INMay 8, 1969 · N3403T · Substantial damage NTSB CHI69D0637Accident · Minor injuriesClosedBoeing A75N1 · Mackey, INMay 7, 1969 · N54945 · Destroyed NTSB CHI69D0634Accident · Minor injuriesClosedBeech V35A · Muncie, INMay 3, 1969 · N8360N · Destroyed NTSB CHI69D0633Accident · No injuriesClosedCessna 177 · Austin, INMay 2, 1969 · N2929X · Substantial damage NTSB CHI69A0090Accident · Serious injuriesClosedCessna 310G · Evansville, INApr 30, 1969 · N8901Z · Destroyed NTSB CHI69D0664Accident · No injuriesClosedCessna 150 · Crawfordsvlle, INApr 26, 1969 · N6450F · Substantial damage NTSB CHI69D0597Accident · No injuriesClosedPiper PA-22 · Kokomo, INApr 20, 1969 · N2830Z · Substantial damage NTSB CHI69D0576Accident · No injuriesClosedPiper PA-24 · Greenwood, INApr 13, 1969 · N7167P · Substantial damage NTSB CHI69D0601Accident · No injuriesClosedCessna 150 · Ft Wayne, INApr 11, 1969 · N8394G · Substantial damage NTSB CHI69D0600Accident · No injuriesClosedCessna 182E · Hartford City, INApr 10, 1969 · N2987Y · Substantial damage NTSB CHI69F0585Accident · No injuriesClosedBeech 36 · Indianapolis, INApr 6, 1969 · N7742R · Substantial damage NTSB CHI69D0599Accident · No injuriesClosedCessna 150 · Hobart, INMar 30, 1969 · N8288S · Substantial damage NTSB CHI69F0560Accident · No injuriesClosedPiper PA-22 · Galveston, INMar 23, 1969 · N6177D · Substantial damage NTSB CHI69D0619Accident · Minor injuriesClosedCessna 175 · Gary, INMar 22, 1969 · N6984E · Substantial damage NTSB CHI69F0556Accident · 1 fatalClosedGibson D · Selma, INMar 19, 1969 · N126G · Destroyed NTSB CHI69D0596Accident · No injuriesClosedCessna 182 · Indianapolis, INMar 15, 1969 · N2890R · Substantial damage NTSB CHI69D0578Accident · No injuriesClosedCessna 182 · Terre Haute, INMar 14, 1969 · N3204U · Substantial damage NTSB CHI69F0552Accident · No injuriesClosedPiper PA-28 · Ft.Wayne, INMar 1, 1969 · N8926W · Substantial damage NTSB CHI69F0517Accident · Minor injuriesClosedPiper PA-28 · South Bend, INMar 1, 1969 · N3555K · Destroyed NTSB CHI69F0534Accident · No injuriesClosedPiper PA-28 · Wabash, INFeb 28, 1969 · N5335L · Substantial damage NTSB CHI69A0075Accident · 1 fatalClosedMooney M20E · Jeffersonvlle, INFeb 28, 1969 · N1274X · Destroyed NTSB CHI69D0499Accident · Minor injuriesClosedStinson 108 · Laurel, INFeb 26, 1969 · N4147C · Substantial damage NTSB CHI69A0074Accident · Serious injuriesClosedCessna 150 · Vincennes, INFeb 17, 1969 · N7868F · 2 aircraft · Minor damage NTSB CHI69I0071Incident · No injuriesClosedN.American NA-265 · Valparaiso, INFeb 12, 1969 · N999BS · Minor damage NTSB CHI69D0524Accident · No injuriesClosedPiper PA-22 · Valparaiso, INFeb 9, 1969 · N9555D · Substantial damage NTSB CHI69F0493Accident · No injuriesClosedPiper PA-28 · Williamsport, INFeb 6, 1969 · N6666W · Substantial damage NTSB CHI69D0460Accident · No injuriesClosedCessna 150 · Washington, INFeb 3, 1969 · N22649 · Substantial damage NTSB CHI69A0069Accident · No injuriesClosedGrumman G-159 · Batesville, INFeb 3, 1969 · N834H · Substantial damage NTSB CHI69D0478Accident · No injuriesClosedMooney M20E · Franklin, INFeb 1, 1969 · N7195U · 2 aircraft · Substantial damage NTSB CHI69F0502Accident · No injuriesClosedTemco D16A · Crown Point, INJan 25, 1969 · N712T · Substantial damage NTSB CHI69A0067Accident · Serious injuriesClosedPiper PA-23 · Avon, INJan 19, 1969 · N3110P · Destroyed NTSB CHI69F0479Accident · Minor injuriesClosedCessna 177 · Shelbyville, INJan 13, 1969 · N2254Y · Substantial damage NTSB CHI69A0065Accident · 2 fatalClosedAeronca 65-TAC · Shelbyville, INJan 11, 1969 · N36925 · Destroyed NTSB CHI69D0434Accident · No injuriesClosedCessna 150 · Marion, INJan 8, 1969 · N3879J · Substantial damage NTSB CHI69F0641Accident · No injuriesClosedCessna 172G · Brownsburg, INDec 31, 1968 · N4215L · Substantial damage NTSB CHI69F0419Accident · No injuriesClosedCessna 421 · Elkhart, INDec 26, 1968 · N3160K · Substantial damage NTSB CHI69D0395Accident · No injuriesClosedAeronca 7AC · Mccordsville, INDec 21, 1968 · N85308 · Substantial damage