Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MIA71DLD43Accident · No injuriesClosedPiper J-3 · Haines City, FLDec 31, 1970 · N9217H · Substantial damage NTSB MIA71DKT30Accident · No injuriesClosedPiper PA-23 · Arcadia, FLDec 31, 1970 · N6680Y · Substantial damage NTSB MIA71AM054Accident · 4 fatalClosedCessna 401A · Ft Lauderdale, FLDec 29, 1970 · N6235Q · Destroyed NTSB MIA71FKT28Accident · No injuriesClosedAero Comdr 520 · Miami, FLDec 28, 1970 · N167L · Substantial damage NTSB MIA71FKT27Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLDec 27, 1970 · N5257Y · Substantial damage NTSB MIA71FLD39Accident · Serious injuriesClosedErco 415-C · Plymouth, FLDec 26, 1970 · N2931H · Substantial damage NTSB MIA71DLD40Accident · No injuriesClosedBellanca 14-13 · Clearwater, FLDec 20, 1970 · N86823 · Substantial damage NTSB MIA71DLA28Accident · No injuriesClosedCessna 172 · Lake Como, FLDec 20, 1970 · N8442L · Substantial damage NTSB MIA71DKT32Accident · Minor injuriesClosedN.American P-51 · Homestead, FLDec 20, 1970 · N1051S · Substantial damage NTSB MIA71DKT29Accident · No injuriesClosedCessna 177 · Ochopee, FLDec 20, 1970 · N2921X · Substantial damage NTSB MIA71FLD38Accident · No injuriesClosedPiper PA-28 · Vero Beach, FLDec 17, 1970 · N5781U · Substantial damage NTSB MIA71FLA29Accident · 2 fatalClosedTaylorcraft BC12-D · Micanopy, FLDec 17, 1970 · N95705 · Destroyed NTSB MIA71AM053Accident · 1 fatalClosedAero Comdr 500-A · Mcalpin, FLDec 16, 1970 · N6170X · Destroyed NTSB MIA71FLA26Accident · No injuriesClosedHughes 269B · Jacksonville, FLDec 13, 1970 · N9518F · Substantial damage NTSB MIA71AM050Accident · 2 fatalClosedBeech 35 · Crystal River, FLDec 12, 1970 · N3077V · Destroyed NTSB MIA71FKT26Accident · No injuriesClosedCessna 320B · Dania, FLDec 6, 1970 · N9832L · Substantial damage NTSB MIA71FKT24Accident · No injuriesClosedAmer Avco AA-1A · Belle Glade, FLDec 5, 1970 · N5633L · Destroyed NTSB MIA71DLA27Accident · No injuriesClosedAeronca 7AC · Ormond Beach, FLDec 5, 1970 · N2432E · Substantial damage NTSB MIA71IM051Incident · No injuriesClosedBoeing 747 · Miami, FLDec 1, 1970 · N735PA · No damage NTSB MIA71FLA23Accident · Minor injuriesClosedDrainville JT · Pensacola, FLNov 29, 1970 · N3929 · Destroyed NTSB MIA71FLA25Accident · No injuriesClosedAero Comdr 100 · Marianna, FLNov 28, 1970 · N3774X · Substantial damage NTSB MIA71FLA24Accident · No injuriesClosedPiper PA-24 · Tallahassee, FLNov 28, 1970 · N5706P · Substantial damage NTSB MIA71FKT25Accident · No injuriesClosedSnow S2A · Clewiston, FLNov 26, 1970 · N9460R · Substantial damage NTSB MIA71FKT21Accident · No injuriesClosedMooney M20F · Ft.Lauderdale, FLNov 26, 1970 · N6427Q · Substantial damage NTSB MIA71FKT20Accident · Minor injuriesClosedCessna 172H · Pahokee, FLNov 26, 1970 · N3809R · Substantial damage NTSB MIA71FLA22Accident · Minor injuriesClosedPitts Webb · Jacksonville, FLNov 22, 1970 · N22WT · Substantial damage NTSB MIA71FLA21Accident · No injuriesClosedPiper PA-23 · Milton, FLNov 22, 1970 · N2297P · Substantial damage NTSB MIA71DLD37Accident · No injuriesClosedCessna 172I · N.Smyrna Bch, FLNov 22, 1970 · N35562 · Substantial damage NTSB MIA71DLA20Accident · No injuriesClosedCessna 140 · Pensacola, FLNov 21, 1970 · N72853 · Substantial damage NTSB MIA71FLD35Accident · No injuriesClosedBeech D18S · Masaryktown, FLNov 12, 1970 · N271P · Substantial damage NTSB MIA71DLD33Accident · No injuriesClosedRepublic RC-3 · Winter Haven, FLNov 8, 1970 · N87537 · Substantial damage NTSB MIA71FLA18Accident · No injuriesClosedCessna 150J · Jacksonville, FLNov 7, 1970 · N60647 · Substantial damage NTSB MIA71FKT18Accident · Minor injuriesClosedBrantly 305 · Miami, FLNov 7, 1970 · N2232U · Substantial damage NTSB MIA71DKT17Accident · No injuriesClosedCessna 150H · Jupiter, FLNov 7, 1970 · N22525 · Substantial damage NTSB MIA71FKT16Accident · Minor injuriesClosedPiper PA-18 · Davie, FLNov 5, 1970 · N4042Z · Substantial damage NTSB MIA71DKT37Accident · No injuriesClosedBrantly 305 · Boca Raton, FLNov 5, 1970 · N2226U · Substantial damage NTSB MIA71FLD32Accident · No injuriesClosedPiper PA-28 · Daytona Beach, FLNov 3, 1970 · N8951W · Substantial damage NTSB MIA71FLD31Accident · Serious injuriesClosedCessna 172 · Seminole, FLOct 31, 1970 · N7816T · Substantial damage NTSB MIA71FLD30Accident · No injuriesClosedCessna 150G · Vero Beach, FLOct 31, 1970 · N6374S · Substantial damage NTSB MIA71DKT15Accident · Minor injuriesClosedBell 47G-2 · Opa Locka, FLOct 31, 1970 · N6761D · Substantial damage NTSB MIA71DKT13Accident · No injuriesClosedPiper J-3 · Homestead, FLOct 31, 1970 · N33484 · Substantial damage NTSB MIA71DKT14Accident · No injuriesClosedBeech 95-B55 · Opa Locka, FLOct 30, 1970 · N8624Q · Substantial damage NTSB MIA71FLA16Accident · No injuriesClosedMooney M20C · Tallahassee, FLOct 25, 1970 · N957MA · Substantial damage NTSB MIA71DLA15Accident · No injuriesClosedLuscombe 8A · Gainesville, FLOct 25, 1970 · N71776 · Substantial damage NTSB MIA71DKT12Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLOct 24, 1970 · N60882 · Substantial damage NTSB MIA71DKT11Accident · No injuriesClosedCessna 172C · Hollywood, FLOct 23, 1970 · N1554Y · Substantial damage NTSB MIA71AM036Accident · 1 fatalClosedPiper J3C-65 · Gainesville, FLOct 23, 1970 · N30723 · Destroyed NTSB MIA71DLD27Accident · No injuriesClosedAerostar 600 · St. Petersbrg, FLOct 22, 1970 · N7429S · Substantial damage NTSB MIA71FLD29Accident · Minor injuriesClosedCessna 172I · Daytona Beach, FLOct 21, 1970 · N46057 · Substantial damage NTSB MIA71DLD28Accident · No injuriesClosedPiper PA-28 · Melbourne, FLOct 21, 1970 · N5520F · Substantial damage