Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MIA73FLD51Accident · Minor injuriesClosedCessna 150L · St.Petersburg, FLDec 29, 1972 · N1423Q · Destroyed NTSB DCA73AZ005Accident · 99 fatalClosedLockheed 1011 · Miami, FLDec 29, 1972 · N310EA · Destroyed NTSB MIA73FLD50Accident · No injuriesClosedBell 47G · Orlando, FLDec 28, 1972 · N184B · Substantial damage NTSB MIA73FLD49Accident · No injuriesClosedLake LA-4P · Redington Bch, FLDec 28, 1972 · N261B · Substantial damage NTSB MIA73DKT42Accident · No injuriesClosedCessna 172 · Evergldes Cty, FLDec 26, 1972 · N7900G · Substantial damage NTSB MIA73FLD48Accident · No injuriesClosedBeech B35 · Avon Park, FLDec 25, 1972 · N1240 · Substantial damage NTSB MIA73AM066Accident · No injuriesClosedGrumman G-73 · Miami, FLDec 23, 1972 · N73556 · Substantial damage NTSB MIA73FKT39Accident · 1 fatalClosedBoeing E75 · Clewiston, FLDec 20, 1972 · N1206M · Destroyed NTSB MIA73DLD44Accident · No injuriesClosedPiper PA-28 · Myakka City, FLDec 18, 1972 · N626FL · Substantial damage NTSB MIA73DKT37Accident · No injuriesClosedCessna 150F · Lake Park, FLDec 18, 1972 · N7012F · Substantial damage NTSB MIA73FLD47Accident · No injuriesClosedPiper PA-28 · Sarasota, FLDec 16, 1972 · N4206T · Substantial damage NTSB MIA73FLA24Accident · No injuriesClosedCessna 310 · Jacksonville, FLDec 16, 1972 · N4849B · Substantial damage NTSB MIA73DLD46Accident · No injuriesClosedPiper PA-22 · Ft Pierce, FLDec 16, 1972 · N5072Z · Substantial damage NTSB MIA73AM062Accident · Minor injuriesClosedBoeing 747 · Miami, FLDec 15, 1972 · N602US · Substantial damage NTSB MIA73FLD43Accident · Minor injuriesClosedStinson 108 · Lake Alfred, FLDec 13, 1972 · N97400 · Substantial damage NTSB MIA73DLD42Accident · No injuriesClosedDenson GN-1 · Tampa, FLDec 13, 1972 · N17RD · Substantial damage NTSB MIA73FLD41Accident · No injuriesClosedBeech B95 · Masaryktown, FLDec 10, 1972 · N2060C · Substantial damage NTSB MIA73FLD40Accident · No injuriesClosedErco 415-C · St.Petersburg, FLDec 10, 1972 · N94114 · Substantial damage NTSB MIA73DLD39Accident · Minor injuriesClosedJeannies T. I · Palma Sola, FLDec 10, 1972 · N3779 · Substantial damage NTSB MIA73DKT35Accident · No injuriesClosedCessna 150 · Belle Glade, FLDec 9, 1972 · N4015U · Substantial damage NTSB MIA73FLA23Accident · No injuriesClosedCessna 310C · Jacksonville, FLDec 7, 1972 · N6698B · Substantial damage NTSB MIA73FKT33Accident · No injuriesClosedPiper PA-12 · Opa Locka, FLDec 5, 1972 · N7955H · Substantial damage NTSB MIA73DKT34Accident · No injuriesClosedBeech D18S · Homestead, FLDec 5, 1972 · N2991 · Substantial damage NTSB MIA73DKT32Accident · Minor injuriesClosedPiper PA-28 · Princeton, FLDec 5, 1972 · N7310F · Destroyed NTSB MIA73DLD38Accident · No injuriesClosedPitts Spcial · Melbourne, FLDec 2, 1972 · N5311 · 2 aircraft · No damage NTSB MIA73DLD36Accident · No injuriesClosedCessna 150 · Winter Haven, FLNov 27, 1972 · N8269S · Substantial damage NTSB MIA73DKT30Accident · No injuriesClosedPiper PA-30 · Ft Lauderdale, FLNov 27, 1972 · N8503Y · Substantial damage NTSB MIA73DLD37Accident · No injuriesClosedLake LA-4 · Ft Pierce, FLNov 26, 1972 · N5025L · Substantial damage NTSB MIA73DKT67Accident · No injuriesClosedBell 47H-1 · Naples, FLNov 26, 1972 · N2818B · Substantial damage NTSB MIA73FKT29Accident · No injuriesClosedCessna 310C · Naples, FLNov 25, 1972 · N6676B · Substantial damage NTSB MIA73FKT28Accident · Serious injuriesClosedCessna A150K · Pompano Beach, FLNov 25, 1972 · N8434M · Substantial damage NTSB MIA73AM057Accident · 4 fatalClosedPiper PA-23 · Jacksonville, FLNov 25, 1972 · N5908Y · Destroyed NTSB MIA73FKT27Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLNov 23, 1972 · N5005P · Substantial damage NTSB MIA73IM055Incident · No injuriesClosedBoeing 747 · Miami, FLNov 22, 1972 · N754PA · Minor damage NTSB MIA73AM056Accident · 1 fatalClosedBell 47G-2 · Miami, FLNov 22, 1972 · N5188B · Destroyed NTSB MIA73FLA22Accident · No injuriesClosedPiper PA-22 · Cantonment, FLNov 20, 1972 · N8626D · Substantial damage NTSB MIA73FLA21Accident · No injuriesClosedBeech 95-55 · St.Augustine, FLNov 19, 1972 · N1248Z · Substantial damage NTSB MIA73DLD33Accident · No injuriesClosedCessna 150L · Inglis, FLNov 19, 1972 · N5310Q · Substantial damage NTSB MIA73FLA20Accident · Serious injuriesClosedHughes 269C · Jacksonville, FLNov 17, 1972 · N9624F · Destroyed NTSB MIA73FLD32Accident · No injuriesClosedPiper PA-28R · Sanford, FLNov 14, 1972 · N7609J · Substantial damage NTSB MIA73FLD30Accident · No injuriesClosedBeech 56TC · Daytona Beach, FLNov 13, 1972 · N5427U · Substantial damage NTSB MIA73DKT25Accident · No injuriesClosedSnow S2A · Clewiston, FLNov 13, 1972 · N4973C · Substantial damage NTSB MIA73DLD31Accident · No injuriesClosedPiper PA-24 · Orlando, FLNov 12, 1972 · N5801P · Substantial damage NTSB MIA73DKT24Accident · No injuriesClosedPiper PA-28 · Clewiston, FLNov 12, 1972 · N9303W · Substantial damage NTSB MIA73FLD35Accident · No injuriesClosedGrumman G44A · Melbourne, FLNov 10, 1972 · N41988 · Substantial damage NTSB MIA73DLD29Accident · No injuriesClosedPiper PA-28 · Sanford, FLNov 9, 1972 · N8292N · Substantial damage NTSB MIA73FLD27Accident · No injuriesClosedCessna A188B · Fort Pierce, FLOct 30, 1972 · N21628 · Substantial damage NTSB MIA73DLD25Accident · No injuriesClosedCessna 172 · Daytona Beach, FLOct 27, 1972 · N84465 · Substantial damage NTSB MIA73DLA19Accident · No injuriesClosedBellanca 14-192 · Woodville, FLOct 27, 1972 · N7688B · Substantial damage NTSB MIA73DLD23Accident · No injuriesClosedWaco RNF · Palma Sola, FLOct 26, 1972 · N11456 · Substantial damage