Skip to content

NTSB investigations, 1977, FL

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MIA78FA024Accident · 4 fatalClosedBeech A24 · Alachua, FLDec 27, 1977 · N6962Q · Destroyed NTSB MIA78FA020Accident · 2 fatalClosedCessna 150 · Plantation, FLDec 23, 1977 · N10608 · Destroyed NTSB MIA78DLA14Accident · No injuriesClosedCessna 172 · St Augustine, FLDec 23, 1977 · N5143R · Substantial damage NTSB MIA78FLA11Accident · No injuriesClosedCessna 310C · Jacksonville, FLDec 22, 1977 · N1757H · Substantial damage NTSB MIA78FLA10Accident · No injuriesClosedLockheed L-18 · Jacksonville, FLDec 21, 1977 · N33FB · Substantial damage NTSB MIA78DKT23Accident · No injuriesClosedHiller UH-12D · Jupiter, FLDec 21, 1977 · N501AG · Destroyed NTSB MIA78DLD18Accident · No injuriesClosedPiper PA-18 · Ft Pierce, FLDec 18, 1977 · N13921 · Substantial damage NTSB MIA78FKT22Accident · Serious injuriesClosedCessna 401 · W.Palm Beach, FLDec 16, 1977 · N80BW · Destroyed NTSB MIA78DKT21Accident · No injuriesClosedGrumman G-164B · Clewiston, FLDec 14, 1977 · N6771Q · Destroyed NTSB MIA78FKT20Accident · Serious injuriesClosedGrumman G-21 · Miami Lakes, FLDec 13, 1977 · N23DF · Destroyed NTSB MIA78FLD15Accident · No injuriesClosedCessna 188 · Zellwood, FLDec 12, 1977 · N21693 · Substantial damage NTSB MIA78DLD14Accident · No injuriesClosedCessna 172 · Valkaria, FLDec 9, 1977 · N3293L · Substantial damage NTSB MIA78FKT18Accident · Serious injuriesClosedCessna 172 · Lantana, FLDec 4, 1977 · N3966Q · Destroyed NTSB MIA77DLD16Accident · No injuriesClosedGlobe GC-1B · Titusville, FLDec 3, 1977 · N90325 · Substantial damage NTSB MIA78FKT17Accident · Serious injuriesClosedCessna 150 · Clewiston, FLDec 2, 1977 · N6666T · Destroyed NTSB MIA78FA017Accident · 1 fatalClosedPiper PA-28 · Lakeport, FLNov 29, 1977 · N5374W · Destroyed NTSB MIA78FKT15Accident · Minor injuriesClosedPiper PA30 · Opa Locka, FLNov 28, 1977 · N7497Y · Substantial damage NTSB MIA78FKT14Accident · No injuriesClosedPiper PA-25 · Boynton Beach, FLNov 26, 1977 · N8735L · Destroyed NTSB MIA78FKT13Accident · Minor injuriesClosedCessna 182 · Clewiston, FLNov 23, 1977 · N3146Y · Substantial damage NTSB MIA78FA014Accident · 2 fatalClosedCessna 150M · Richland, FLNov 20, 1977 · N7586U · Destroyed NTSB MIA78FLD13Accident · Minor injuriesClosedCessna 172 · Rockledge, FLNov 19, 1977 · N8647B · Substantial damage NTSB MIA78FLD12Accident · Serious injuriesClosedBeech D18 · Orlando, FLNov 19, 1977 · N270QS · Destroyed NTSB MIA78FLD11Accident · No injuriesClosedCessna 152 · Seffner, FLNov 15, 1977 · N757HV · Substantial damage NTSB MIA78DLD10Accident · No injuriesClosedSchleicher ASW-17 · Mulberry, FLNov 13, 1977 · N4AX · 2 aircraft · Substantial damage NTSB MIA78DKT28Accident · No injuriesClosedCessna 170B · Ft Myers, FLNov 11, 1977 · N2480D · Substantial damage NTSB MIA77FLA06Accident · No injuriesClosedHughes 269B · Gainesville, FLNov 8, 1977 · N9482F · Substantial damage NTSB MIA78FA011Accident · 1 fatalClosedCessna 150J · Sugarloaf Key, FLNov 5, 1977 · N51027 · Destroyed NTSB MIA78FKJ06Accident · No injuriesClosedAero Comdr S2R · Jay, FLNov 1, 1977 · N4227X · Destroyed NTSB MIA78DKT04Accident · No injuriesClosedBeech C-45H · Naples, FLNov 1, 1977 · N213S · Substantial damage NTSB MIA78FLD09Accident · No injuriesClosedCessna 172 · Lake Wales, FLOct 30, 1977 · N4476R · Substantial damage NTSB MIA78FA010Accident · 2 fatalClosedCessna 150L · Inverness, FLOct 30, 1977 · N18732 · Destroyed NTSB MIA77FKT86Accident · Minor injuriesClosedGrum Amer AA-1B · Coral Springs, FLOct 29, 1977 · N9979L · Substantial damage NTSB MIA78FA008Accident · 2 fatalClosedLet-Np-K L-13 · Pensacola, FLOct 27, 1977 · N779 · Destroyed NTSB MIA78IA007Incident · No injuriesClosedBeech D-18S · Miami, FLOct 24, 1977 · N123EM · Minor damage NTSB MIA78DLD06Accident · No injuriesClosedPiper J3 · Ft Pierce, FLOct 23, 1977 · N70701 · Substantial damage NTSB MIA78DKT10Accident · No injuriesClosedPiper PA-34 · Ft.Meyers, FLOct 23, 1977 · N6206J · Substantial damage NTSB MIA78FKT09Accident · No injuriesClosedHiller UH12D · Miami, FLOct 22, 1977 · N62360 · Substantial damage NTSB MIA78DKT08Accident · No injuriesClosedHiller Acft UH-12D · Miami, FLOct 22, 1977 · N9299Z · Substantial damage NTSB MIA77DLD05Accident · No injuriesClosedCessna 172 · Brooksville, FLOct 22, 1977 · N734ZP · Substantial damage NTSB MIA77FLD08Accident · No injuriesClosedPiper PA-24 · Tampa, FLOct 20, 1977 · N7330P · Substantial damage NTSB MIA78FLA03Accident · No injuriesClosedErco 415-C · Lake City, FLOct 16, 1977 · N99166 · Substantial damage NTSB MIA78DLD04Accident · No injuriesClosedFairchild F24 · Titusville, FLOct 15, 1977 · N81378 · Substantial damage NTSB MIA78FA006Accident · 3 fatalClosedCessna 150 · Cedar Key, FLOct 14, 1977 · N9116U · Destroyed NTSB MIA78FA004Accident · No injuriesClosedCurtis-Wrt C-46F · Miami, FLOct 13, 1977 · N74177 · Substantial damage NTSB MIA78IA001Incident · Minor injuriesClosedLockheed 1011 · Orlando, FLOct 9, 1977 · N320EA · No damage NTSB MIA78FKT06Accident · No injuriesClosedAero Comdr S2R · Florida City, FLOct 9, 1977 · N8502V · Destroyed NTSB MIA78DLD02Accident · No injuriesClosedCessna 177M · Daytona Beach, FLOct 6, 1977 · N6864H · 2 aircraft · Substantial damage NTSB MIA78FLA02Accident · No injuriesClosedMooney M20F · St Augustine, FLOct 5, 1977 · N9356V · Substantial damage NTSB MIA78FLD01Accident · No injuriesClosedMong Sport · De Leon Spring, FLOct 1, 1977 · N65U · Substantial damage NTSB MIA78FLA01Accident · No injuriesClosedPiper PA-28R · St Augustine, FLOct 1, 1977 · N32172 · Substantial damage