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 CHI74AC020Accident · 2 fatalClosedCessna 337A · Gary, INSep 4, 1973 · N6270F · 2 aircraft · Destroyed NTSB CHI74DET07Accident · Minor injuriesClosedLuscombe 8F · Crown Point, INAug 31, 1973 · N1883B · Substantial damage NTSB CHI74FEA09Accident · No injuriesClosedPiper PA-24 · Lanesville, INAug 26, 1973 · N8552P · Substantial damage NTSB CHI74DEA12Accident · No injuriesClosedPiper PA-28 · Radnor, INAug 26, 1973 · N6018W · Substantial damage NTSB CHI74AC016Accident · Serious injuriesClosedAero Comdr 520 · Michigan City, INAug 25, 1973 · N2634B · Destroyed NTSB CHI74AC015Accident · 1 fatalClosedStinson L-5E · Demotte, INAug 19, 1973 · N5163V · Destroyed NTSB CHI74FET06Accident · No injuriesClosedCessna 310C · Griffith, INAug 18, 1973 · N1845H · Substantial damage NTSB CHI74FET04Accident · No injuriesClosedPiper PA-23 · Walton, INAug 7, 1973 · N436CB · Substantial damage NTSB CHI74DEA08Accident · No injuriesClosedPiper PA-25 · Kentland, INAug 4, 1973 · N6569Z · Destroyed NTSB CHI74DET05Accident · No injuriesClosedPiper PA-25 · Morocco, INAug 2, 1973 · N7761Z · Substantial damage NTSB CHI74AC010Accident · 1 fatalClosedPiper PA-28R · Fountaintown, INAug 1, 1973 · N2102T · Destroyed NTSB CHI74DET02Accident · Serious injuriesClosedJeanies TWO · Merriville, INJul 30, 1973 · N4X · Substantial damage NTSB CHI74FEA06Accident · No injuriesClosedPiper PA-22 · Hartford City, INJul 28, 1973 · N3033Z · Substantial damage NTSB CHI74DEA10Accident · No injuriesClosedPiper PA-28 · Kokomo, INJul 27, 1973 · N5219T · Substantial damage NTSB CHI74DEA07Accident · No injuriesClosedGreat Lakes Baby · Anderson, INJul 15, 1973 · N132SP · Substantial damage NTSB CHI74FEA04Accident · Serious injuriesClosedBell 47G-3 · Dana, INJul 13, 1973 · N8416E · Substantial damage NTSB CHI74FEA11Accident · No injuriesClosedCessna 210D · Evansville, INJul 8, 1973 · N3804Y · Substantial damage NTSB CHI74FEA03Accident · No injuriesClosedBell 47G-2A · Little York, INJul 5, 1973 · N73257 · Substantial damage NTSB CHI74DEA05Accident · No injuriesClosedPitts S1-D · Greentown, INJul 5, 1973 · N6RD · Substantial damage NTSB CHI74FEA02Accident · No injuriesClosedAeronca 7AC · Speedway, INJul 4, 1973 · N84304 · Substantial damage NTSB CHI74AC003Accident · 4 fatalClosedCessna 172F · No.Webster, INJul 4, 1973 · N5526R · Destroyed NTSB CHI74AC001Accident · 4 fatalClosedCessna T210J · Pleasant Lake, INJul 2, 1973 · N20EA · Destroyed NTSB CHI74FEA01Accident · Minor injuriesClosedCessna 210 · North Vernon, INJul 1, 1973 · N9538T · Substantial damage NTSB CHI73FET25Accident · Minor injuriesClosedChampion 7KCAB · Griffith, INJun 25, 1973 · CF-ASI · Substantial damage NTSB CHI73DEA42Accident · No injuriesClosedPiper PA-20 · Portland, INJun 25, 1973 · N8290C · Substantial damage NTSB CHI73DEA40Accident · No injuriesClosedCessna 150F · Mc Cordsville, INJun 24, 1973 · N6427F · Substantial damage NTSB CHI73DEA39Accident · No injuriesClosedCessna 172 · Hagerstown, INJun 24, 1973 · N1642E · Substantial damage NTSB CHI73DEA41Accident · No injuriesClosedCessna 182 · Ramsey, INJun 22, 1973 · N5035D · Substantial damage NTSB CHI73FEA38Accident · Serious injuriesClosedBeech 23 · Lanesville, INJun 13, 1973 · N1493L · Destroyed NTSB CHI73AC095Accident · 1 fatalClosedRyan ST-3KR · Greenfield, INJun 9, 1973 · N47368 · Destroyed NTSB CHI73FET24Accident · No injuriesClosedCessna 170B · New Paris, INJun 8, 1973 · N8292A · Substantial damage NTSB CHI73DEA35Accident · No injuriesClosedCessna A188A · Greentown, INJun 8, 1973 · N9930G · Destroyed NTSB CHI73DEA37Accident · No injuriesClosedBell 47D-1 · Bloomfield, INJun 5, 1973 · N2794A · Destroyed NTSB CHI73FET22Accident · Minor injuriesClosedHughes 269A · Gary, INMay 28, 1973 · N8790F · Substantial damage NTSB CHI73DET21Accident · No injuriesClosedPiper PA-28 · Culver, INMay 25, 1973 · N576FL · Substantial damage NTSB CHI73AC091Accident · No injuriesClosedPiper PA-32 · Portland, INMay 24, 1973 · N3778W · Destroyed NTSB CHI73AEA36Accident · No injuriesClosedHughes 269C · De Pauw, INMay 22, 1973 · N9609F · Substantial damage NTSB CHI73DEA34Accident · No injuriesClosedCessna 172 · Mt.Vernon, INMay 20, 1973 · N19984 · Substantial damage NTSB CHI73AC087Accident · 2 fatalClosedPiper PA-22 · Indianapolis, INMay 8, 1973 · N3378B · Destroyed NTSB CHI73DEA33Accident · No injuriesClosedEFF Graham Midget · Seymour, INMay 5, 1973 · N2793 · Substantial damage NTSB CHI73DEA32Accident · No injuriesClosedCessna 150 · Noblesville, INApr 21, 1973 · N19392 · Substantial damage NTSB CHI73FET17Accident · No injuriesClosedChampion 7GCAA · Kendallville, INApr 7, 1973 · N9574S · Substantial damage NTSB CHI73FET16Accident · Minor injuriesClosedPiper PA-23 · Auburn, INApr 7, 1973 · N2265P · Substantial damage NTSB CHI73FEA31Accident · No injuriesClosedStinson 108-3 · Carmel, INApr 5, 1973 · N747C · Substantial damage NTSB CHI73FET15Accident · Minor injuriesClosedCessna 150J · Angola, INApr 1, 1973 · N60717 · Substantial damage NTSB CHI73AEA30Accident · Minor injuriesClosedCessna 172M · Lafayette, INMar 30, 1973 · N20644 · Substantial damage NTSB CHI73FEA28Accident · No injuriesClosedPiper PA-24 · Jeffersonvlle, INMar 21, 1973 · N8263P · Substantial damage NTSB CHI73DET18Accident · No injuriesClosedBeech A23 · Griffith, INMar 18, 1973 · N3533R · Substantial damage NTSB CHI73DET14Accident · No injuriesClosedPiper PA-28 · Laporte, INMar 18, 1973 · N9358J · Substantial damage NTSB CHI73AC075Accident · 1 fatalClosedPiper PA-28 · Knox, INMar 16, 1973 · N5377L · Destroyed