NTSB investigations, 1976, 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 NYC77IA021Incident · No injuriesClosedBoeing 747 · San Juan, PRDec 12, 1976 · N9664 · Minor damage NTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRDec 12, 1976 · N9954L · Destroyed NTSB MIA77DKA03Accident · Minor injuriesClosedPiper PA-32 · Isla Verde, PRDec 4, 1976 · N3334W · Destroyed NTSB MIA77DKA02Accident · No injuriesClosedGrum Amer AA-1B · Manati, PRNov 9, 1976 · N1492R · Substantial damage NTSB MIA77FKA01Accident · No injuriesClosedGrumman G-164 · Yauco, PRNov 1, 1976 · N460Y · Substantial damage NTSB MIA76DKA08Accident · No injuriesClosedCessna 310 · Vieques, PRSep 29, 1976 · N8010M · Substantial damage NTSB MIA78FKA09Accident · No injuriesClosedPiper PA-28 · Las Marias, PRSep 22, 1976 · N5941U · Destroyed NTSB MIA76DKA06Accident · No injuriesClosedCessna 150L · Moca, PRMay 16, 1976 · N1707Q · Substantial damage NTSB MIA76FKA05Accident · Minor injuriesClosedCessna 411 · San Juan, PRApr 15, 1976 · N73344 · Destroyed