Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 MIA79DLD30Accident · No injuriesClosedCessna 175 · Clearwater, FLDec 30, 1978 · N7521M · Substantial damage NTSB MIA79DLA13Accident · No injuriesClosedCessna 185 · Deland, FLDec 30, 1978 · N4544F · Substantial damage NTSB MIA79FLD28Accident · No injuriesClosedBell 47J2A · Kissimmee, FLDec 27, 1978 · N3099G · Substantial damage NTSB MIA79FLD27Accident · No injuriesClosedBeech 95-B55 · Arcadia, FLDec 27, 1978 · N5716V · Substantial damage NTSB MIA79FA032Accident · 2 fatalClosedBeech E33 · Arcadia, FLDec 26, 1978 · N1043A · Destroyed NTSB MIA79DLD26Accident · No injuriesClosedPiper PA-22 · Lakeland, FLDec 26, 1978 · N8943C · Destroyed NTSB MIA79DLA1ZAccident · No injuriesClosedBeech 58 · Cross Cty, FLDec 24, 1978 · N9408Q · Substantial damage NTSB MIA79DLD25Accident · No injuriesClosedCessna 182 · Brandon, FLDec 23, 1978 · N8861T · Substantial damage NTSB MIA79DKT25Accident · No injuriesClosedCessna 152 · Palm Beach, FLDec 23, 1978 · N24287 · Substantial damage NTSB MIA79DKT24Accident · Minor injuriesClosedCessna 185 · Key West, FLDec 22, 1978 · N2673Z · Substantial damage NTSB MIA79FLD29Accident · No injuriesClosedBeech C35 · Brooksville, FLDec 19, 1978 · N45X · Substantial damage NTSB MIA79FLD24Accident · No injuriesClosedSikorsky S-55B · Haines, FLDec 19, 1978 · N6489 · Substantial damage NTSB MIA79FKJ15Accident · 1 fatalClosedPitts S-1 · Panama City, FLDec 18, 1978 · N4GP · Destroyed NTSB MIA79FLD23Accident · No injuriesClosedMooney M-20C · Windemere, FLDec 16, 1978 · N74572 · Substantial damage NTSB MIA79FA031Accident · No injuriesClosedDouglas DC-3C · Belle Glade, FLDec 14, 1978 · N4996E · Substantial damage NTSB MIA79FA030Accident · 2 fatalClosedDouglas DC-3 · Port Mayaca, FLDec 11, 1978 · N133AC · Destroyed NTSB MIA79DKT15Accident · No injuriesClosedCessna 172 · W Palm Beach, FLDec 10, 1978 · N2425L · Substantial damage NTSB MIA79DKT18Accident · No injuriesClosedCessna 150 · Labelle, FLDec 7, 1978 · N6173K · Substantial damage NTSB MIA79DKT16Accident · No injuriesClosedBeech 18 · Palm Beach, FLDec 6, 1978 · N189R · Substantial damage NTSB MIA79FA027Accident · 3 fatalClosedDouglas DC3 · Lorida, FLDec 5, 1978 · N25656 · Destroyed NTSB MIA79FLD22Accident · No injuriesClosedSwearingen SAT226 · Ft Pierce, FLDec 4, 1978 · N97AB · Substantial damage NTSB MIA79FA026Accident · 2 fatalClosedBeagle 206 · Miami, FLDec 2, 1978 · N568MA · Destroyed NTSB MIA79FA024Accident · 1 fatalClosedGrumman AA-5B · Marianna, FLNov 30, 1978 · N28649 · Destroyed NTSB MIA79DLD21Accident · No injuriesClosedCessna 152 · Mulberry, FLNov 30, 1978 · N49433 · Substantial damage NTSB MIA79FA021Accident · 1 fatalClosedConvair 240 · Miami, FLNov 29, 1978 · LVMMR · Destroyed NTSB MIA79FLD20Accident · No injuriesClosedBeech B19 · Sebring, FLNov 26, 1978 · N2171W · Substantial damage NTSB MIA79FKT22Accident · No injuriesClosedPiper PA-34 · Ft.Lauderdale, FLNov 24, 1978 · N15229 · Substantial damage NTSB MIA79FA018Accident · 1 fatalClosedPiper PA-28 · Osteen, FLNov 22, 1978 · N5362W · Destroyed NTSB MIA79DKJ13Accident · No injuriesClosedCessna 140 · Careyville, FLNov 22, 1978 · N72244 · Substantial damage NTSB MIA79FA016Accident · 2 fatalClosedCessna 337E · Daytona Beach, FLNov 21, 1978 · N86540 · Destroyed NTSB MIA79FA015Accident · 3 fatalClosedCessna 172N · Ormond Beach, FLNov 20, 1978 · N733QV · Destroyed NTSB MIA79FA014Accident · 2 fatalClosedPiper PA-23 · Ormond Beach, FLNov 20, 1978 · N3485P · Destroyed NTSB MIA79FKT14Accident · Minor injuriesClosedPiper PA-34 · Opa Locka, FLNov 19, 1978 · N1387T · Substantial damage NTSB MIA79DLD18Accident · No injuriesClosedCessna 152 · Silver Springs, FLNov 18, 1978 · N25952 · Substantial damage NTSB MIA79DLD17Accident · No injuriesClosedPiper PA-28 · Sarasota, FLNov 16, 1978 · N702FL · Substantial damage NTSB MIA79DLD16Accident · No injuriesClosedHiller UH12C · Ft Myers, FLNov 15, 1978 · N46937 · Substantial damage NTSB MIA79DLA09Accident · No injuriesClosedCessna 172 · Live Oak, FLNov 13, 1978 · N8459L · Substantial damage NTSB MIA79FLD15Accident · 1 fatalClosedHoffman X2 · Tarpon Springs, FLNov 12, 1978 · N1736 · Destroyed NTSB MIA79FA017Accident · 1 fatalClosedPiper PA-28 · Jacksonville, FLNov 12, 1978 · N3409Q · Destroyed NTSB MIA79DKT19Accident · No injuriesClosedCessna 177B · Key West, FLNov 12, 1978 · N11771 · Substantial damage NTSB MIA79FLD19Accident · No injuriesClosedPiper PA-30 · Sanford, FLNov 10, 1978 · N7555Y · Substantial damage NTSB MIA79DKT26Accident · No injuriesClosedGrumman G-164A · Belle Glade, FLNov 10, 1978 · N7484 · Substantial damage NTSB MIA79FA013Accident · 2 fatalClosedCessa 152 · Boca Raton, FLNov 6, 1978 · N48905 · Destroyed NTSB MIA79FA008Accident · No injuriesClosedCessna 421B · Miami, FLNov 3, 1978 · N391E · Substantial damage NTSB MIA79FLD14Accident · No injuriesClosedCessna C-182R · Avon Park, FLNov 2, 1978 · N3206C · Substantial damage NTSB MIA79DLD13Accident · Minor injuriesClosedCessna 150 · Plymouth, FLNov 2, 1978 · N18059 · Destroyed NTSB MIA79DLD12Accident · No injuriesClosedBellanca 17-30A · Orlando, FLNov 2, 1978 · N39832 · Substantial damage NTSB MIA79DLA06Accident · No injuriesClosedCessna 150J · Jacksonville, FLNov 1, 1978 · N60537 · Substantial damage NTSB MIA79FLD06Accident · No injuriesClosedPiper PA-30 · Ft Pierce, FLOct 31, 1978 · N7708Y · Substantial damage NTSB MIA79FA007Accident · 2 fatalClosedPiper PA-34 · Titusville, FLOct 30, 1978 · N1058U · Destroyed