Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MIA80FLD25Accident · No injuriesClosedCessna 210 · Odessa, FLDec 31, 1979 · N6465N · Substantial damage NTSB MIA80FLA09Accident · No injuriesClosedPiper PA-23 · Jacksonville, FLDec 30, 1979 · N1063P · Substantial damage NTSB MIA80FLD26Accident · No injuriesClosedPitts S-1C · Odessa, FLDec 29, 1979 · N8NS · Substantial damage NTSB MIA80FLA13Accident · Minor injuriesClosedBeech C-23 · Jacksonville, FLDec 25, 1979 · N5171M · Substantial damage NTSB MIA80FA022Accident · 4 fatalClosedBeech E18S · Orlando, FLDec 22, 1979 · N198B · Destroyed NTSB MIA80FLD22Accident · No injuriesClosedPiper PA-28 · Tampa, FLDec 20, 1979 · N16EC · Substantial damage NTSB MIA80DLD29Accident · No injuriesClosedPiper PA-38 · Zephyrhills, FLDec 19, 1979 · N801JC · Substantial damage NTSB MIA80FLD24Accident · No injuriesClosedPiper PA-30 · Vero Beach, FLDec 17, 1979 · N7737Y · Substantial damage NTSB MIA80DLD21Accident · No injuriesClosedBeech 95-B55 · Ft Pierce, FLDec 16, 1979 · N8GS · Substantial damage NTSB MIA80FA018Accident · 4 fatalClosedRaven S-55A · Davie, FLDec 15, 1979 · N64RR · Destroyed NTSB MIA80DLA11Accident · Minor injuriesClosedCessna 152 · Tallahassee, FLDec 13, 1979 · N24243 · Substantial damage NTSB MIA80FKT08Accident · No injuriesClosedCessna 177RG · Boca Raton, FLDec 11, 1979 · N2010Q · Substantial damage NTSB MIA80FLD19Accident · No injuriesClosedCessna 210D · Titusville, FLDec 10, 1979 · N5FD · Substantial damage NTSB MIA80DLD20Accident · No injuriesClosedBeech C33 · Ocala, FLDec 9, 1979 · N5869S · Substantial damage NTSB MIA80FA017Accident · 2 fatalClosedPiper PA-24 · Clearwater, FLDec 6, 1979 · N9095P · Destroyed NTSB MIA8OFA016Accident · 2 fatalClosedPiper PA-23 · Pembroke Pines, FLDec 5, 1979 · N6883Y · Destroyed NTSB MIA80FA015Accident · 2 fatalClosedAmer Avco AA1-B · Melbourne, FLNov 29, 1979 · N8971L · Destroyed NTSB MIA80FKT17Accident · Serious injuriesClosedPiper PA-32 · Miami, FLNov 28, 1979 · N3762W · Destroyed NTSB MIA80DLD17Accident · No injuriesClosedPiper PA-18 · Okeechobee, FLNov 28, 1979 · N6734L · Substantial damage NTSB MIA80FKT16Accident · No injuriesClosedMaule M-5 · Pompano Beach, FLNov 26, 1979 · N5636B · Substantial damage NTSB MIA80FLA08Accident · Minor injuriesClosedPiper PA-31 · Jacksonville, FLNov 25, 1979 · N20KA · Destroyed NTSB MIA80DLA07Accident · No injuriesClosedAeronca 7BCM · Tallahassee, FLNov 24, 1979 · N75369 · Substantial damage NTSB MIA80DLD18Accident · No injuriesClosedSchweizer SGS135 · Lakeland, FLNov 23, 1979 · N34185 · Substantial damage NTSB MIA80DLD15Accident · Serious injuriesClosedJantar STD SZD-41 · Winter Haven, FLNov 23, 1979 · N60AS · Substantial damage NTSB MIA80DLD16Accident · No injuriesClosedCessna 210 · Ft.Myers, FLNov 22, 1979 · N2188S · Substantial damage NTSB MIA80DLD14Accident · No injuriesClosedPiper PA-28 · New Pt Richey, FLNov 22, 1979 · N3623M · Substantial damage NTSB MIA80FLD12Accident · Serious injuriesClosedCessna 172 · Titusville, FLNov 19, 1979 · N7338E · Substantial damage NTSB MIA80FLD23Accident · No injuriesClosedBellanca 7GCBC · Tampa, FLNov 18, 1979 · N5045G · Substantial damage NTSB MIA80DLD13Accident · Serious injuriesClosedBalloon WKS KS-7 · Plant City, FLNov 17, 1979 · N41JB · Minor damage NTSB MIA80DLD11Accident · Minor injuriesClosedCessna 182 · Ocala, FLNov 15, 1979 · N52742 · Substantial damage NTSB MIA80FKT13Accident · No injuriesClosedBeech 58 · Miami, FLNov 11, 1979 · N98SC · Substantial damage NTSB MIA80DLD09Accident · No injuriesClosedHughes 269B · Winter Haven, FLNov 10, 1979 · N9393F · Substantial damage NTSB MIA80DLD08Accident · No injuriesClosedCessna 152 · Cedar Key, FLNov 9, 1979 · N24308 · Substantial damage NTSB MIA80FLD10Accident · No injuriesClosedPiper PA-24 · Vero Beach, FLNov 4, 1979 · N7499P · Substantial damage NTSB MIA80FLD05Accident · No injuriesClosedLuscombe 8A · Plymouth, FLNov 4, 1979 · N2345K · Substantial damage NTSB MIA80DLD07Accident · No injuriesClosedCessna 180 · Brooksville, FLNov 4, 1979 · N3122C · Substantial damage NTSB MIA80DLD02Accident · No injuriesClosedCessna 152 · Sebastian, FLOct 28, 1979 · N64923 · Destroyed NTSB MIA80FLD04Accident · No injuriesClosedPiper PA-23 · Fort Myers, FLOct 27, 1979 · N640CC · Substantial damage NTSB MIA80DKT09Accident · Minor injuriesClosedCessna 152 · Highland Beach, FLOct 27, 1979 · N89705 · Substantial damage NTSB MIA80DLA06Accident · Minor injuriesClosedBellanca 7GCAA · Archer, FLOct 26, 1979 · N2515Z · Destroyed NTSB MIA80FLD03Accident · Minor injuriesClosedAero Comdr 600S2R · Ft Myers, FLOct 25, 1979 · N8963Q · Substantial damage NTSB MIA80FKT05Accident · No injuriesClosedAero Comdr 680 · Clewiston, FLOct 23, 1979 · N5MZ · Substantial damage NTSB MIA80FA006Accident · 1 fatalClosedSikorsky S-55 · Davenport, FLOct 23, 1979 · N95761 · Destroyed NTSB MIA80DLD06Accident · No injuriesClosedCessna 185F · Ft. Meyers, FLOct 21, 1979 · N86330 · Substantial damage NTSB MIA80FA004Accident · 1 fatalClosedPitts S-2A · Bunnell, FLOct 20, 1979 · N17DG · Destroyed NTSB MIA80FLA05Accident · Serious injuriesClosedCessna A188B · Alachua, FLOct 19, 1979 · N731UT · Substantial damage NTSB MIA80FLA03Accident · Serious injuriesClosedCessna 172M · Interlachen, FLOct 18, 1979 · N21524 · Substantial damage NTSB MIA80DLA01Accident · Minor injuriesClosedBeech F33A · Perry, FLOct 8, 1979 · N6376S · Substantial damage NTSB MIA80FA001Accident · 2 fatalClosedCessna 210 · Osteen, FLOct 7, 1979 · N1738X · Destroyed NTSB MIA80DLA02Accident · Serious injuriesClosedPiper PA-28 · Bunnell, FLOct 7, 1979 · N404FL · Destroyed