Skip to content

NTSB investigations, 1971, FL

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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MIA72FKT37Accident · No injuriesClosedPiper PA-30 · Boca Chica, FLDec 31, 1971 · N718JR · Substantial damage NTSB MIA72DLA24Accident · No injuriesClosedPiper PA-28 · High Springs, FLDec 27, 1971 · N5202L · Substantial damage NTSB MIA72FLD41Accident · No injuriesClosedStinson 108-1 · Oklawaha, FLDec 24, 1971 · N8470K · Substantial damage NTSB MIA72FLA23Accident · Minor injuriesClosedCessna 177 · Carrabelle, FLDec 24, 1971 · N2393Y · Substantial damage NTSB MIA72FKT36Accident · No injuriesClosedCallair A-9B · W Palm Beach, FLDec 24, 1971 · N7992V · Substantial damage NTSB MIA72DKT35Accident · No injuriesClosedCessna 172G · Miami, FLDec 23, 1971 · N3778L · Substantial damage NTSB MIA72DLA27Accident · No injuriesClosedCessna 182 · Apalachicola, FLDec 22, 1971 · N3367U · Substantial damage NTSB MIA72DKT39Accident · No injuriesClosedCessna 140 · Deerfld Beach, FLDec 20, 1971 · N2938N · Substantial damage NTSB MIA72DLD23Accident · No injuriesClosedPiper PA-30 · Bartow, FLDec 19, 1971 · N8113Y · Substantial damage NTSB MIA72DLA26Accident · Minor injuriesClosedBell 47D1 · Milton, FLDec 17, 1971 · N3109G · Substantial damage NTSB MIA72FLD31Accident · No injuriesClosedPiper J3L-65 · Avon Park, FLDec 13, 1971 · N30842 · Substantial damage NTSB MIA72FLD30Accident · Serious injuriesClosedPiper PA-22 · New Smrna, FLDec 10, 1971 · N5195Z · Destroyed NTSB MIA72DLD32Accident · No injuriesClosedPiper PA-28 · Kissimmee, FLDec 9, 1971 · N8012N · Substantial damage NTSB MIA72FLA25Accident · No injuriesClosedCessna 337A · Mcintosh, FLDec 8, 1971 · N6357F · Substantial damage NTSB MIA72FLA22Accident · Serious injuriesClosedCessna 150L · Jacksonville, FLDec 8, 1971 · N6877G · Destroyed NTSB MIA72DKT34Accident · No injuriesClosedCessna 150 · W Palm Beach, FLDec 7, 1971 · N6031G · Substantial damage NTSB MIA72AM053Accident · 2 fatalClosedPiper PA-24 · Lamont, FLDec 7, 1971 · N7867P · Destroyed NTSB MIA72FLA21Accident · Serious injuriesClosedCessna 172F · Gainesville, FLDec 4, 1971 · N8721U · Substantial damage NTSB MIA72DLA20Accident · No injuriesClosedPiper PA-24 · Gainesville, FLDec 4, 1971 · CF-MNP · Substantial damage NTSB MIA72AM051Accident · No injuriesClosedHughes 269C · Hallandale, FLDec 3, 1971 · N9621F · Substantial damage NTSB MIA72FKT33Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLNov 30, 1971 · N2279P · Substantial damage NTSB MIA72FKT32Accident · Serious injuriesClosedAeronca 7AC · Belle Glade, FLNov 29, 1971 · N82473 · Destroyed NTSB MIA72DLD27Accident · No injuriesClosedCessna 150J · Osteen, FLNov 28, 1971 · N50830 · Destroyed NTSB MIA72DLD28Accident · No injuriesClosedCessna 150 · Orlando, FLNov 27, 1971 · N22750 · Substantial damage NTSB MIA72IM049Incident · Minor injuriesClosedDouglas DC-10 · Miami, FLNov 26, 1971 · N60NA · No damage NTSB MIA72FLD26Accident · No injuriesClosedCessna 172 · Tampa, FLNov 25, 1971 · N6485B · Substantial damage NTSB MIA72FKT30Accident · No injuriesClosedGlobe GC-1B · Sanibel Isld, FLNov 21, 1971 · N80990 · Substantial damage NTSB MIA72AM048Accident · No injuriesClosedBeech 99A · Ft.Lauderdale, FLNov 21, 1971 · N860SA · Substantial damage NTSB MIA72AM046Accident · No injuriesClosedCessna 150K · Opa Locka, FLNov 18, 1971 · N5922G · 2 aircraft · Substantial damage NTSB MIA72DLD23Accident · No injuriesClosedCessna 150 · Bartow, FLNov 9, 1971 · N51027 · Substantial damage NTSB MIA72DLD25Accident · No injuriesClosedEnstrom F-28A · Orlando, FLNov 7, 1971 · N9554 · No damage NTSB MIA72DLD22Accident · No injuriesClosedCessna 150H · Odessa, FLNov 7, 1971 · N6647S · Substantial damage NTSB MIA72DKT26Accident · No injuriesClosedPiper PA-25 · Ft Myers, FLNov 1, 1971 · N6976Z · Substantial damage NTSB MIA72DLD20Accident · No injuriesClosedCessna 150 · Sanford, FLOct 30, 1971 · N6783G · Substantial damage NTSB MIA72DLD19Accident · No injuriesClosedAero Comdr 500 · Titusville, FLOct 29, 1971 · N6291B · Substantial damage NTSB MIA72FLA19Accident · No injuriesClosedPiper PA-31 · Pensacola, FLOct 28, 1971 · N41DL · Substantial damage NTSB MIA72DLA18Accident · Minor injuriesClosedCessna 150G · Micanopy, FLOct 28, 1971 · N3281J · Substantial damage NTSB MIA72FLA17Accident · No injuriesClosedCessna 172E · Compass Lake, FLOct 24, 1971 · N919DD · Substantial damage NTSB MIA72DKT23Accident · No injuriesClosedPiper PA-16 · Ft Lauderdale, FLOct 24, 1971 · N5917H · Substantial damage NTSB MIA72DLD21Accident · No injuriesClosedCessna 170 · Oviedo, FLOct 23, 1971 · N2694V · Substantial damage NTSB MIA72DLD17Accident · No injuriesClosedCessna 320C · Ocala, FLOct 23, 1971 · N3050T · Substantial damage NTSB MIA72DLA16Accident · Minor injuriesClosedCessna 177 · Gainesville, FLOct 23, 1971 · N30446 · Substantial damage NTSB MIA72AM041Accident · 4 fatalClosedBeech 95-B55 · St.Petersburg, FLOct 23, 1971 · N8427N · Destroyed NTSB MIA72FLD18Accident · No injuriesClosedPiper PA-17 · Arcadia, FLOct 21, 1971 · N4677H · Destroyed NTSB MIA72FKT22Accident · No injuriesClosedBell 47D-1 · South Bay, FLOct 20, 1971 · N160B · Substantial damage NTSB MIA72AM039Accident · No injuriesClosedLockheed 1049H · Miami, FLOct 20, 1971 · N6912C · Substantial damage NTSB MIA72FKT25Accident · No injuriesClosedCessna 310N · W Palm Beach, FLOct 18, 1971 · N6977L · Substantial damage NTSB MIA72DLD16Accident · No injuriesClosedPiper PA-28 · Ocoee, FLOct 18, 1971 · N8025N · Substantial damage NTSB MIA72FLA15Accident · No injuriesClosedCessna 150 · Pensacola, FLOct 16, 1971 · N5873G · Substantial damage NTSB MIA72AM035Accident · No injuriesClosedLockheed 18-56 · Jacksonville, FLOct 14, 1971 · N669 · Substantial damage