NTSB investigations, 1977, PR

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19622026

NTSB investigations, 1977, PR per year, 1962–2026: 409 cases
1962	1
1964	32
1965	28
1966	19
1967	25
1968	18
1969	19
1970	14
1971	15
1972	10
1973	11
1974	7
1975	14
1976	9
1977	11
1978	10
1979	13
1980	13
1981	15
1984	1
1999	1
2001	8
2002	7
2003	4
2004	6
2005	6
2006	6
2007	7
2008	4
2009	6
2010	9
2011	3
2012	5
2013	4
2014	4
2015	8
2016	3
2017	5
2018	6
2019	3
2020	4
2022	3
2023	2
2024	4
2025	3
2026	3

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 year(c."eventDate") = 1977 AND c."eventStateOrRegion" = 'PR' 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 year(c.\"eventDate\") = 1977
    AND c.\"eventStateOrRegion\" = 'PR' 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 year(c."eventDate") = 1977
  AND c."eventStateOrRegion" = 'PR' 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 MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · Destroyed NTSB MIA78DKA04Accident · No injuriesClosedCessna 172 · Utuado, PRDec 5, 1977 · N2160Y · Substantial damage NTSB MIA78FKA01Accident · Minor injuriesClosedCessna 337 · San Juan, PRNov 10, 1977 · N2194X · Destroyed NTSB MIA77DA070Accident · Serious injuriesClosedBeech 65B80 · Ponce, PRJul 12, 1977 · N99JL · Destroyed NTSB MIA77FA058Accident · No injuriesClosedGrumman G-73 · San Juan, PRMay 17, 1977 · N7338 · Substantial damage NTSB MIA77FA053Accident · No injuriesClosedDouglas DC-3 · San Juan, PRApr 14, 1977 · N28392 · Substantial damage NTSB MIA77DKA05Accident · Minor injuriesClosedPiper PA-23 · San Juan, PRApr 6, 1977 · N5519Y · Destroyed NTSB MIA77FKA06Accident · No injuriesClosedAero Comdr 100 · Lajas, PRApr 3, 1977 · N4037X · Substantial damage NTSB MIA77FKA04Accident · Serious injuriesClosedMooney M20E · Ponce, PRApr 2, 1977 · N6841V · No damage NTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRFeb 17, 1977 · N4046G · Destroyed NTSB MIA77FA028Accident · No injuriesClosedCurtiss C-46A · San Juan, PRFeb 8, 1977 · HI-208 · Destroyed