Skip to content

NTSB investigations, VI

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year

19652026

Latest cases

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" = 'VI' 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\" = 'VI' 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" = 'VI' 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 MIA82DA024Incident · No injuriesClosedHawker Sdly HS-748 · St Thomas, VIDec 27, 1981 · VP-LIP · Minor damage NTSB MIA82FA006Accident · 3 fatalClosedLockheed 749 · St Thomas, VIOct 26, 1981 · HI-328 · Destroyed NTSB MIA81DKA09Accident · No injuriesClosedCurtis-Wrt C-46 · St.Croix, VISep 28, 1981 · HI-209 · Substantial damage NTSB MIA81FA105Accident · 4 fatalClosedAero Comdr 680FL · St.Croix, VIAug 16, 1981 · N6600M · Destroyed NTSB MIA81FA099Accident · 1 fatalClosedPiper PA-23 · St.Thomas, VIJul 23, 1981 · N1349P · Destroyed NTSB MIA81FKA07Accident · Minor injuriesClosedBeech S35 · St. Thomas, VIJun 28, 1981 · N8620Q · Destroyed NTSB MIA81FA088Accident · No injuriesClosedBeech 65-80 · St.Croix, VIJun 26, 1981 · N314Q · Substantial damage NTSB MIA81IA058Incident · Minor injuriesClosedDehavilland DH-114 · St Thomas, VIMar 27, 1981 · N583PR · Minor damage NTSB MIA80DA061Accident · 1 fatalClosedPiper PA-28R · St.Thomas, VIMay 4, 1980 · N751R · Destroyed NTSB NYC80FA033Accident · Minor injuriesClosedGrumman G-73 · St Croix, VIApr 7, 1980 · N26DF · Substantial damage NTSB MIA80DKA06Accident · Serious injuriesClosedBellanca 7ECA · St.Thomas, VIMar 23, 1980 · N9532S · Destroyed NTSB MIA80FKA04Accident · No injuriesClosedPiper PA-23 · St.Thomas, VIJan 18, 1980 · N238PS · Destroyed NTSB MIA80FA029Accident · Serious injuriesClosedPiper PA-31 · St.Croix, VIJan 18, 1980 · N25VM · Destroyed NTSB MIA80IA103Incident · No injuriesClosedDouglas DC3C · St Thomas, VIDec 27, 1979 · N100SD · Minor damage NTSB DCA79AA020Accident · 8 fatalClosedDehavilland DH-114 · St Croix, VIJul 24, 1979 · N575PR · Destroyed NTSB MIA79FKA07Accident · No injuriesClosedCessna 172 · St.Croix, VIJun 28, 1979 · N2949U · Substantial damage NTSB MIA79FA011Accident · No injuriesClosedGrumman G21A · St Croix, VINov 5, 1978 · N74676 · Substantial damage NTSB DCA78AA021Accident · 4 fatalClosedGrumman G-21A · St Thomas, VISep 2, 1978 · N7777V · Destroyed NTSB MIA78FA093Accident · No injuriesClosedGrumman G21A · St.Thomas, VIJun 4, 1978 · N323 · Substantial damage NTSB MIA78FA060Accident · 2 fatalClosedGrumman G-21 · St Thomas, VIApr 5, 1978 · N877A · Destroyed NTSB MIA78FKA02Accident · No injuriesClosedCurtis-Wrt C-46 · St Thomas, VINov 3, 1977 · N67971 · Substantial damage NTSB MIA77DKA07Accident · No injuriesClosedErco 415-C · St.Thomas, VIAug 28, 1977 · N87011 · Destroyed NTSB MIA77FA024Accident · No injuriesClosedBrittnorman BN2A-8 · St.Thomas, VIJan 14, 1977 · N121DW · Substantial damage NTSB DCA76AZ025Accident · 37 fatalClosedBoeing 727 · St.Thomas, VIApr 27, 1976 · N1963 · Destroyed NTSB MIA76FKA04Accident · Serious injuriesClosedCessna 150 · St Thomas, VIApr 14, 1976 · N7663U · Destroyed NTSB MIA76DKA03Accident · Minor injuriesClosedCessna 185 · St Thomas, VIFeb 25, 1976 · N181U · Destroyed NTSB MIA76AM066Accident · 5 fatalClosedGrumman G-21A · St Croix, VIFeb 21, 1976 · N4772C · Destroyed NTSB MIAMLAM050Accident · Minor injuriesClosedBrittnorman BN-2A · St Thomas, VIDec 12, 1975 · N118DW · Destroyed NTSB MIA75AM070Accident · No injuriesClosedBeech D18 · St Thomas, VIMar 6, 1975 · N28Y · Substantial damage NTSB MIA75AM025Accident · No injuriesClosedBrittnorman BN-2A · St Thomas, VINov 1, 1974 · N80JA · No damage NTSB MIA74AM091Accident · Minor injuriesClosedGrumman G-21A · St Thomas, VIMay 7, 1974 · N1048V · Substantial damage NTSB MIA74FKA06Accident · Minor injuriesClosedCessna 177 · St Thomas, VIDec 19, 1973 · N2229Y · Substantial damage NTSB MIA74FKA04Accident · No injuriesClosedHiller Acft UH-12A · St Thomas, VISep 12, 1973 · N8151H · Substantial damage NTSB MIA73AM063Accident · No injuriesClosedHawker-Sdly HS748 · St.Croix, VIMay 1, 1973 · VP-LIK · Substantial damage NTSB MIA73FKA01Accident · No injuriesClosedLake LA-4 · Charltte Amlie, VIJul 21, 1972 · N7627L · Substantial damage NTSB MIA72FKA07Accident · No injuriesClosedCessna 150 · St Thomas, VIDec 5, 1971 · N3532 · Substantial damage NTSB MIA72IM024Incident · No injuriesClosedGrumman G-21A · St.Croix, VISep 4, 1971 · N4762C · No damage NTSB MIA72DKA03Accident · No injuriesClosedChampion 7GCBC · St.John, VIAug 18, 1971 · N2531F · Substantial damage NTSB MIA71AM106Accident · No injuriesClosedCessna 185A · Charltte Amlie, VIMay 31, 1971 · N169E · Substantial damage NTSB MIA71AM100Accident · Minor injuriesClosedGrumman G-21A · Charlotte Amal, VIMay 23, 1971 · N8777A · Substantial damage NTSB MIA71AM113Accident · No injuriesClosedHam-Flugzeu HFB320 · St Croix, VIMay 9, 1971 · N380EX · Substantial damage NTSB MIA71AM091Accident · 8 fatalClosedBeech E18S · C.Amalie, VIApr 21, 1971 · N456T · Destroyed NTSB DCA71AZ014Accident · 2 fatalClosedBoeing 727 · St Thomas, VIDec 28, 1970 · N8790R · Destroyed NTSB MIA71AM047Accident · No injuriesClosedConvair 640 · St.Thomas, VIDec 10, 1970 · N3417 · Substantial damage NTSB MIA71AM042Accident · No injuriesClosedConvair 28-5AC · Christiansted, VINov 14, 1970 · N5584V · Substantial damage NTSB MIA71FKA08Accident · No injuriesClosedCessna 150K · St.Croix, VINov 9, 1970 · N5917J · Substantial damage NTSB DCA70AZ007Accident · 23 fatalClosedDouglas DC-9 · St.Croix, VIMay 2, 1970 · N935F · Destroyed NTSB MIA70AM073Accident · Minor injuriesClosedGrumman G-21A · St Thomas, VIFeb 28, 1970 · N40R · Substantial damage NTSB MIA70F0274Accident · No injuriesClosedCessna 310 · St.Thomas, VIDec 4, 1969 · N126X · Substantial damage NTSB MIA70A0042Accident · Serious injuriesClosedDehavilland DH114 · Charlotte Amal, VIDec 1, 1969 · N570PR · Substantial damage