Skip to content

NTSB investigations, 1975, FL

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1975, FL per year, 1962–2026: 10,190 cases
1962	7
1963	6
1964	199
1965	231
1966	227
1967	258
1968	206
1969	197
1970	214
1971	205
1972	234
1973	254
1974	238
1975	218
1976	203
1977	220
1978	250
1979	242
1980	261
1981	208
1982	190
1983	219
1984	230
1985	212
1986	217
1987	200
1988	187
1989	183
1990	147
1991	158
1992	131
1993	147
1994	175
1995	136
1996	137
1997	146
1998	162
1999	143
2000	138
2001	120
2002	134
2003	136
2004	120
2005	150
2006	133
2007	150
2008	133
2009	103
2010	103
2011	110
2012	101
2013	91
2014	101
2015	99
2016	96
2017	97
2018	120
2019	113
2020	92
2021	97
2022	82
2023	83
2024	103
2025	105
2026	82

Where

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") = 1975 AND c."eventStateOrRegion" = 'FL' 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\") = 1975
    AND c.\"eventStateOrRegion\" = 'FL' 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") = 1975
  AND c."eventStateOrRegion" = 'FL' 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 MIA76FLD37Accident · Minor injuriesClosedPiper PA-28 · Vero Beach, FLDec 30, 1975 · N1966T · Destroyed NTSB MIA76DKT39Accident · Minor injuriesClosedCessna 182E · Miami, FLDec 30, 1975 · N3204Y · Destroyed NTSB MIA76DKT53Accident · Minor injuriesClosedGrum Amer AA1-B · Pompano Beach, FLDec 26, 1975 · N9868L · Substantial damage NTSB MIA76DLD35Accident · No injuriesClosedGrumman G-164A · Zellwood, FLDec 23, 1975 · N770ZF · Substantial damage NTSB MIA76FKT37Accident · Minor injuriesClosedCessna 150 · Miami, FLDec 22, 1975 · N50312 · Substantial damage NTSB MIA76AM054Accident · 1 fatalClosedCessna 150 · Jupiter, FLDec 21, 1975 · N17228 · Destroyed NTSB MIA76FLD34Accident · No injuriesClosedPiper PA-34 · St Petersburg, FLDec 20, 1975 · N1044U · Substantial damage NTSB MIA76AM053Accident · 5 fatalClosedNavion B · Cross City, FLDec 20, 1975 · N5275K · Destroyed NTSB MIA76DLD33Accident · No injuriesClosedGrum-Amer AA5 · Orlando, FLDec 12, 1975 · N5874L · Substantial damage NTSB MIA76FLD31Accident · No injuriesClosedGrumman G-164A · Zellwood, FLDec 10, 1975 · N772ZF · Substantial damage NTSB MIA76DLD32Accident · No injuriesClosedPiper PA-28 · Daytona Beach, FLDec 10, 1975 · N404FL · Substantial damage NTSB MIA76DLA29Accident · No injuriesClosedCessna 310Q · Gainsville, FLDec 10, 1975 · N1270G · Substantial damage NTSB MIA76FKT49Accident · No injuriesClosedPiper PA-23 · Ft Lauderdale, FLDec 4, 1975 · N13916 · Substantial damage NTSB MIA76AM049Accident · 3 fatalClosedMooney M20C · Cross City, FLDec 1, 1975 · N78974 · Destroyed NTSB MIA76FLA27Accident · No injuriesClosedPiper PA-28 · Fernandina Bch, FLNov 30, 1975 · N8179N · Substantial damage NTSB MIA76AM048Accident · 2 fatalClosedCessna 337G · Boca Raton, FLNov 29, 1975 · N97C · Destroyed NTSB MIA76FLD30Accident · Minor injuriesClosedCessna 337 · Titusville, FLNov 28, 1975 · N997RL · Substantial damage NTSB MIA76DKT31Accident · No injuriesClosedCessna 337 · Miami, FLNov 27, 1975 · N1259M · Substantial damage NTSB MIA76FKT32Accident · Serious injuriesClosedBell 206B · Delray Beach, FLNov 26, 1975 · N750LT · Destroyed NTSB MIA76AM047Accident · 1 fatalClosedCessna 185 · St Petersburg, FLNov 26, 1975 · N445J · Substantial damage NTSB MIA76DLA24Accident · Minor injuriesClosedCessna 172 · Keystone Hts, FLNov 24, 1975 · N2847U · Substantial damage NTSB MIA76AM046Accident · No injuriesClosedCessna 210E · Tampa, FLNov 23, 1975 · N48122 · Substantial damage NTSB MIA76FLA26Accident · No injuriesClosedPiper PA-28 · Jacksonville, FLNov 21, 1975 · N1769T · Substantial damage NTSB MIA76AM044Accident · 1 fatalClosedPiper PA-20 · Lighthouse Pt, FLNov 21, 1975 · N7427K · Destroyed NTSB MIA76FLA25Accident · Minor injuriesClosedCessna 185F · Gainesville, FLNov 19, 1975 · N1301F · Substantial damage NTSB MIA76DLD29Accident · No injuriesClosedBoeing A75N1 · Lake Placid, FLNov 18, 1975 · N5506A · Substantial damage NTSB MIA76DLD13Accident · No injuriesClosedPiper PA-28 · Englewood, FLNov 17, 1975 · N8403R · Substantial damage NTSB MIA76FLA22Accident · No injuriesClosedCessna 150M · Tallahassee, FLNov 13, 1975 · N66154 · Substantial damage NTSB MIA76DLA23Accident · No injuriesClosedCessna 150 · Live Oak, FLNov 13, 1975 · N63558 · Substantial damage NTSB MIA76AM041Accident · 1 fatalClosedCessna 172L · Key West, FLNov 8, 1975 · N3913Q · Destroyed NTSB MIA76DKT30Accident · No injuriesClosedCessna 150 · Punta Gorda, FLNov 4, 1975 · N50670 · Substantial damage NTSB MIA76FLA21Accident · Serious injuriesClosedCessna 172M · Callahan, FLNov 3, 1975 · N64098 · Substantial damage NTSB MIA76FLD28Accident · No injuriesClosedGlobe GC-1B · Umatilla, FLNov 2, 1975 · N80532 · Substantial damage NTSB MIA76FLA20Incident · No injuriesClosedPiper PA-32 · Jacksonville, FLNov 2, 1975 · N1355T · Minor damage NTSB MIA76AM040Accident · 3 fatalClosedPiper PA-28R · Lake Hamilton, FLNov 2, 1975 · N1191X · Destroyed NTSB MIA76AM038Accident · 1 fatalClosedTaylorcraft BC12-D · Rockledge, FLOct 28, 1975 · N96067 · Destroyed NTSB MIA76AM037Accident · 2 fatalClosedCessna 172M · Marco Island, FLOct 28, 1975 · N20945 · Destroyed NTSB MIA76AM036Accident · 2 fatalClosedTed Smith 600 · Bunnell, FLOct 28, 1975 · N90390 · Destroyed NTSB MIA76DLD27Accident · No injuriesClosedCessna 150L · Lutz, FLOct 26, 1975 · N6722G · Substantial damage NTSB MIA76DLD26Accident · No injuriesClosedBeech A23-24 · Vero Beach, FLOct 21, 1975 · N6953Q · Substantial damage NTSB MIA76FKT24Accident · Minor injuriesClosedPiper J-3 · Indiantown, FLOct 19, 1975 · N7175H · Substantial damage NTSB MIA76AM033Accident · 1 fatalClosedCessna 150M · Hawthorne, FLOct 19, 1975 · N66406 · Destroyed NTSB MIA76FLA17Accident · Serious injuriesClosedBellanca 7ECA · Yulee, FLOct 18, 1975 · N2050Z · Substantial damage NTSB MIA76DLA19Accident · No injuriesClosedCessna 337 · Pensacola, FLOct 18, 1975 · N5491S · Substantial damage NTSB MIA76DKT28Accident · No injuriesClosedTomcat MK5B · Homestead, FLOct 17, 1975 · N4227A · Substantial damage NTSB MIA76FLA16Accident · Minor injuriesClosedPitts S-1 · Jacksonville, FLOct 12, 1975 · N3514 · Substantial damage NTSB MIA76FLD25Accident · No injuriesClosedBeech B35 · Sanford, FLOct 11, 1975 · N129KB · Substantial damage NTSB MIA76IM031Incident · No injuriesClosedDouglas DC-3 · Jacksonville, FLOct 6, 1975 · N32 · Minor damage NTSB MIA76FLD23Accident · 1 fatalClosedKen Land KR-1 · Brooksville, FLSep 30, 1975 · N4AH · Destroyed NTSB MIA76FLD22Accident · Minor injuriesClosedBeech D18S · Cedar Key, FLSep 28, 1975 · N9758 · Substantial damage