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 CHI67D0639Accident · No injuriesClosedBeech 95-B55 · Tell City, INApr 21, 1967 · N8653Q · Substantial damage NTSB CHI68D0017Accident · No injuriesClosedCessna 172 · Rensselaer, INApr 17, 1967 · N6051R · Substantial damage NTSB CHI67D0643Accident · No injuriesClosedPiper PA-22 · Spiceland, INApr 7, 1967 · N5070Z · Substantial damage NTSB CHI67F0604Accident · No injuriesClosedBeech A23 · Gary, INApr 5, 1967 · N5995S · Substantial damage NTSB CHI67D0619Accident · No injuriesClosedCessna 150 · Fort Wayne, INApr 4, 1967 · N8232F · Substantial damage NTSB CHI67F0618Accident · No injuriesClosedCessna 205A · Portage, INApr 1, 1967 · N4873U · Substantial damage NTSB CHI67D0567Accident · No injuriesClosedCessna 150 · Bloomington, INMar 30, 1967 · N4063U · Substantial damage NTSB CHI67A0110Accident · 4 fatalClosedCessna 182 · Gary, INMar 27, 1967 · N3687U · Destroyed NTSB CHI67A0109Accident · 1 fatalClosedPiper PA-22 · Mishawaka, INMar 26, 1967 · N8688C · Destroyed NTSB CHI67A0104Accident · 3 fatalClosedCessna 210 · Bainbridge, INMar 17, 1967 · N9462T · Destroyed NTSB CHI67A0102Accident · 1 fatalClosedCessna 210A · Plymouth, INMar 15, 1967 · N6683X · Destroyed NTSB CHI67F0570Accident · Serious injuriesClosedBeech D50A · Solsberry, INMar 8, 1967 · N5636D · Substantial damage NTSB CHI67F0551Accident · No injuriesClosedPiper PA-30 · Seymour, INMar 8, 1967 · N7841Y · Substantial damage NTSB CHI67D0545Accident · No injuriesClosedCessna 170A · Angola, INMar 7, 1967 · N1341D · Substantial damage NTSB CHI67D0516Accident · No injuriesClosedPiper PA-24 · Bethlehem, INMar 4, 1967 · N5688P · Substantial damage NTSB CHI67D0519Accident · No injuriesClosedPiper PA-22 · Muncie, INMar 1, 1967 · N7047B · Substantial damage NTSB CHI67D0476Accident · No injuriesClosedPiper PA-28 · Frankfort, INFeb 12, 1967 · N5633W · Substantial damage NTSB CHI67F0478Accident · No injuriesClosedChampion 7ECA · Gary, INFeb 11, 1967 · N2569F · Substantial damage NTSB CHI67A0095Accident · No injuriesClosedAero Comdr 520 · Columbia City, INFeb 10, 1967 · N4197B · Substantial damage NTSB CHI67A0094Accident · 2 fatalClosedCessna 150 · Kokomo, INFeb 8, 1967 · N5535E · Destroyed NTSB CHI67F0467Accident · No injuriesClosedCessna 140 · Elkhart, INFeb 5, 1967 · N2264V · Substantial damage NTSB CHI67D0513Accident · No injuriesClosedCessna 182 · Brownsburg, INFeb 4, 1967 · N9988B · Substantial damage NTSB CHI67D0532Accident · No injuriesClosedStinson 108-2 · Clinton, INFeb 2, 1967 · N9276K · Substantial damage NTSB CHI67F0469Accident · No injuriesClosedCessna 182 · Rising Sun, INJan 29, 1967 · N8749T · Substantial damage NTSB CHI67F0441Accident · No injuriesClosedMooney M20C · Ft Wayne, INJan 29, 1967 · N3471X · Substantial damage NTSB CHI67D0463Accident · No injuriesClosedCessna 205 · Greencastle, INJan 28, 1967 · N8397Z · Substantial damage NTSB CHI67F0561Accident · 2 fatalClosedBeech B95 · Bloomington, INJan 25, 1967 · N399Z · Destroyed NTSB CHI67D0458Accident · No injuriesClosedCessna 182 · Noblesville, INJan 22, 1967 · N3373S · Substantial damage NTSB CHI67D0477Accident · No injuriesClosedChampion 7ECA · Ramsey, INJan 20, 1967 · N11097 · Substantial damage NTSB CHI67D0460Accident · No injuriesClosedPiper PA-28 · Rensselaer, INJan 17, 1967 · N6347W · Substantial damage NTSB CHI67D0459Accident · No injuriesClosedPiper PA-28 · Gary, INJan 17, 1967 · N6383R · Substantial damage NTSB CHI67D0448Accident · No injuriesClosedCessna 150A · Newport, INJan 11, 1967 · N7012X · Substantial damage NTSB CHI67A0085Accident · No injuriesClosedPiper PA-24 · Richmond, INJan 9, 1967 · N8984P · Substantial damage NTSB CHI67D0439Accident · No injuriesClosedCessna 182 · Indianapolis, INJan 7, 1967 · N5992B · Substantial damage NTSB CHI67F0461Accident · No injuriesClosedPiper PA-22 · Elkhart, INJan 3, 1967 · N8717C · Substantial damage NTSB CHI67F0433Accident · No injuriesClosedBellanca 14-13 · Warsaw, INDec 30, 1966 · N86771 · Substantial damage NTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INDec 26, 1966 · N2558U · Substantial damage NTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INDec 25, 1966 · N2919N · Substantial damage NTSB CHI67F0438Accident · Serious injuriesClosedAero Comdr 680F · Elkhart, INDec 19, 1966 · N342WS · Destroyed NTSB CHI67F0405Accident · No injuriesClosedCessna 175A · Martinsville, INDec 17, 1966 · N6997E · Substantial damage NTSB CHI67D0373Accident · No injuriesClosedCessna 182 · Indianapolis, INNov 29, 1966 · N3006F · Substantial damage NTSB CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNov 28, 1966 · N4054P · Substantial damage NTSB CHI67F0378Accident · No injuriesClosedCessna 150 · Angola, INNov 26, 1966 · N6497T · Destroyed NTSB CHI67D0364Accident · No injuriesClosedPiper PA-32 · Richmond, INNov 26, 1966 · N3342N · Substantial damage NTSB CHI67A0069Accident · 1 fatalClosedBeech A23 · Forest, INNov 26, 1966 · N1439L · Destroyed NTSB CHI67F0383Accident · No injuriesClosedN.American 265-40 · Evansville, INNov 23, 1966 · N355MJ · Substantial damage NTSB CHI67F0294Accident · No injuriesClosedCessna 150 · Lewis, INNov 12, 1966 · N3769J · Substantial damage NTSB CHI67F0391Accident · No injuriesClosedCessna 310D · Griffith, INNov 5, 1966 · N664R · Substantial damage NTSB CHI67I0059Incident · No injuriesClosedDouglas DC-6B · Ft.Wayne, INNov 2, 1966 · N37575 · Minor damage NTSB CHI67D0357Accident · No injuriesClosedPiper PA-28 · Logansport, INOct 25, 1966 · N4563R · Substantial damage