Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 MIA74DKT45Accident · No injuriesClosedCessna 180 · Delray Beach, FLDec 29, 1973 · N4571B · Substantial damage NTSB MIA74FKT44Accident · No injuriesClosedPiper PA-18A · Ft Lauderdale, FLDec 27, 1973 · N8573D · Substantial damage NTSB MIA74AM050Accident · Minor injuriesClosedDouglas DC3A · W.Palm Beach, FLDec 27, 1973 · N19428 · Substantial damage NTSB MIA74FLA26Accident · No injuriesClosedBeech 65 · Gainsville, FLDec 25, 1973 · N330CB · Substantial damage NTSB MIA74FLD49Accident · 1 fatalClosedPitts S1C · Leesburg, FLDec 23, 1973 · N7J · Destroyed NTSB MIA74DLA29Accident · No injuriesClosedStinson 108-1 · Pensacola, FLDec 23, 1973 · N8869K · Substantial damage NTSB MIA74DLD48Accident · No injuriesClosedCessna 172 · St Petersburg, FLDec 21, 1973 · N46466 · Substantial damage NTSB MIA74D5T43Accident · No injuriesClosedMaule M4-220 · Ft Lauderdale, FLDec 18, 1973 · N2034U · Substantial damage NTSB DCA74AZ013Accident · 3 fatalClosedLockheed 1049H · Miami, FLDec 15, 1973 · N6917C · Destroyed NTSB MIA74DLD46Accident · No injuriesClosedEL Tomcat 47 · Arcadia, FLDec 14, 1973 · N208B · Substantial damage NTSB MIA74DLD51Accident · No injuriesClosedBeech A24R · Cocoa Beach, FLDec 13, 1973 · N24625 · Substantial damage NTSB MIA74DKT50Accident · No injuriesClosedCessna 172 · Miami, FLDec 13, 1973 · N8443U · Substantial damage NTSB MIA74FKT41Accident · No injuriesClosedAero Comdr 112 · Opa Locka, FLDec 7, 1973 · N1105J · Substantial damage NTSB MIA74FLA28Accident · No injuriesClosedBeech 65-80 · Crestview, FLDec 5, 1973 · N741H · Substantial damage NTSB MIA74DLA27Accident · No injuriesClosedCessna 175 · Cherry Lake, FLDec 5, 1973 · N7366M · Substantial damage NTSB MIA74DLD44Accident · Minor injuriesClosedRepublic RC-3 · Umatilla, FLDec 2, 1973 · N6277K · Substantial damage NTSB MIA74DLD45Accident · No injuriesClosedMooney M20F · Ft Pierce, FLNov 27, 1973 · N6424Q · Substantial damage NTSB MIA74FLD47Accident · 1 fatalClosedJodel F-12 · Ormond Beach, FLNov 25, 1973 · N9DH · Destroyed NTSB MIA74FLA25Accident · No injuriesClosedMaule M4220C · Ft George, FLNov 25, 1973 · N40650 · Substantial damage NTSB MIA74DLA24Accident · No injuriesClosedCessna 210 · Tallahassee, FLNov 25, 1973 · N6638X · Substantial damage NTSB MIA74AM047Accident · 4 fatalClosedCessna 182P · Key West, FLNov 22, 1973 · N21312 · Destroyed NTSB MIA74FLA23Accident · No injuriesClosedPiper PA-24 · Jacksonville, FLNov 20, 1973 · N5549P · Substantial damage NTSB MIA74DKT39Accident · No injuriesClosedCessna 150 · Clewiston, FLNov 20, 1973 · N5646E · Substantial damage NTSB MIA74FLD43Accident · No injuriesClosedCessna A188B · Zellwood, FLNov 19, 1973 · N21717 · Destroyed NTSB MIA74AM044Accident · 1 fatalClosedCessna 337 · Ft Lauderdale, FLNov 19, 1973 · N333DD · Destroyed NTSB MIA74FLA22Accident · Minor injuriesClosedStinson 108 · Baker, FLNov 18, 1973 · N97378 · Substantial damage NTSB MIA74DKT38Accident · No injuriesClosedCamair 480 · Lantana, FLNov 17, 1973 · N215 · Substantial damage NTSB MIA74DKT52Accident · No injuriesClosedGrumman G-44 · Dry Tortugas, FLNov 11, 1973 · N2PS · Substantial damage NTSB MIA74DLD40Accident · No injuriesClosedBeech C35 · Orange Lake, FLNov 10, 1973 · N5850C · Substantial damage NTSB MIA74DLA21Accident · No injuriesClosedPiper PA-39 · Lake Como, FLNov 10, 1973 · N8868Y · Substantial damage NTSB MIA74DLD34Accident · No injuriesClosedMooney M20A · Plant City, FLNov 9, 1973 · N6079X · Substantial damage NTSB MIA74DRT37Accident · No injuriesClosedCessna 150 · Miami, FLNov 8, 1973 · N5292Q · Substantial damage NTSB MIA74FKT36Accident · No injuriesClosedRepublic RC-3 · Dania, FLNov 6, 1973 · N6059K · Substantial damage NTSB MIA74DKT34Accident · No injuriesClosedPiper PA-28 · Sanibel Isle, FLNov 4, 1973 · N1685T · Substantial damage NTSB MIA74FLD36Accident · No injuriesClosedCessna P206B · Kissimmee, FLNov 2, 1973 · N4750F · Substantial damage NTSB MIA74DKT31Accident · No injuriesClosedPiper PA-28 · Pompano Beach, FLOct 29, 1973 · N71CA · Substantial damage NTSB MIA74ALD35Accident · Serious injuriesClosedBell 47G-2 · Ft Pierce, FLOct 28, 1973 · N2883B · Substantial damage NTSB MIA74DKT33Accident · Minor injuriesClosedThompson Craft · Lantana, FLOct 26, 1973 · N661 · Substantial damage NTSB MIA74DKT32Accident · No injuriesClosedCessna 210 · W Palm Beach, FLOct 26, 1973 · N3806Y · Substantial damage NTSB MIA74DKT30Accident · No injuriesClosedAeronca 7DC · Homestead, FLOct 25, 1973 · N81741 · Substantial damage NTSB MIA74AM038Accident · Serious injuriesClosedDouglas DC-6B · Miami, FLOct 25, 1973 · N614SE · Destroyed NTSB MIA74DLD38Accident · No injuriesClosedCessna 182 · Daytona, FLOct 23, 1973 · N8384S · Substantial damage NTSB MIA74AM037Accident · No injuriesClosedCurtis-Wrt C-46A · Lakeland, FLOct 23, 1973 · N611Z · Substantial damage NTSB MIA74FKT28Accident · No injuriesClosedPiper PA-28 · Hallandale, FLOct 22, 1973 · N9094J · Substantial damage NTSB MIA74IM036Incident · No injuriesClosedDehavilland DH114 · Miami, FLOct 19, 1973 · N510FW · Substantial damage NTSB MIA74AM039Accident · 4 fatalClosedCessna 172K · Kissimmee, FLOct 18, 1973 · N46575 · Destroyed NTSB MIA74AM034Accident · 2 fatalClosedPiper PA-28R · Fort Pierce, FLOct 18, 1973 · N15482 · Substantial damage NTSB MIA74AM035Accident · 1 fatalClosedCessna 150G · Titusville, FLOct 17, 1973 · N1642M · Destroyed NTSB MIA74AM032Accident · No injuriesClosedAmer Avco AA1-A · Venice, FLOct 15, 1973 · N9374L · Substantial damage NTSB MIA74FKT27Accident · Serious injuriesClosedBeech H18 · Ft Lauderdale, FLOct 14, 1973 · N925N · Substantial damage