Skip to content

NTSB investigations, 1969, FL

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MIA70D0288Accident · No injuriesClosedCessna 182K · Titusville, FLDec 31, 1969 · N2879R · Substantial damage NTSB MIA70A0051Accident · 4 fatalClosedBeech V35A · Tampa, FLDec 31, 1969 · N8351N · Destroyed NTSB MIA70D0281Accident · No injuriesClosedCessna 150 · Defuniak Spgs, FLDec 29, 1969 · N7886F · Substantial damage NTSB MIA70F0260Accident · No injuriesClosedBeech A23 · Opa Locka, FLDec 27, 1969 · N3647Q · Substantial damage NTSB MIA70D0276Accident · No injuriesClosedCessna 310B · Sanibel, FLDec 27, 1969 · N664B · Substantial damage NTSB MIA70F0289Accident · No injuriesClosedBellanca 14-193 · Jacksonville, FLDec 22, 1969 · N8826R · Substantial damage NTSB MIA70F0266Accident · No injuriesClosedCessna 180 · Homestead, FLDec 20, 1969 · N4571B · Substantial damage NTSB MIA70F0263Accident · Minor injuriesClosedLuscombe 8E · Largo, FLDec 11, 1969 · N1399B · Substantial damage NTSB MIA70A0045Accident · No injuriesClosedCurtiss-Wrt C-46F · Tampa, FLDec 9, 1969 · N67938 · Substantial damage NTSB MIA70A0043Accident · 1 fatalClosedCessna 170B · Ft.Lauderdale, FLDec 5, 1969 · N3001W · Destroyed NTSB MIA70F0244Accident · Minor injuriesClosedBeech 95 · Pompano Beach, FLDec 2, 1969 · N2742Y · Substantial damage NTSB MIA70A0038Accident · No injuriesClosedDouglas DC-8 · Miami, FLNov 20, 1969 · N8602 · Substantial damage NTSB MIA70F0240Accident · No injuriesClosedBoeing A75N1 · Immokalee, FLNov 17, 1969 · N52126 · Substantial damage NTSB MIA70I0037Incident · No injuriesClosedBoeing 727 · Mccoy Afbase, FLNov 14, 1969 · N4619 · Minor damage NTSB MIA70D0261Accident · No injuriesClosedPiper PA-28 · Sanford, FLNov 12, 1969 · N5598U · Substantial damage NTSB MIA70D0253Accident · No injuriesClosedSnow S-2R · Ft.Pierce, FLNov 3, 1969 · N1757S · Substantial damage NTSB MIA70F0258Accident · No injuriesClosedScweizer SGS233 · Jacksonville, FLNov 2, 1969 · N5738S · Substantial damage NTSB MIA70F0269Accident · No injuriesClosedAero Comdr 500-A · Tallahassee, FLNov 1, 1969 · N6170X · Substantial damage NTSB MIA70F0208Accident · No injuriesClosedBoeing PT-17 · Homestead, FLOct 26, 1969 · N66576 · Substantial damage NTSB MIA70F0218Accident · No injuriesClosedCessna 182 · Ft.Lauderdale, FLOct 21, 1969 · N70633 · Substantial damage NTSB MIA70D0199Accident · No injuriesClosedPiper PA-28 · Ft Lauderdale, FLOct 20, 1969 · N7551R · Destroyed NTSB MIA70F0197Accident · No injuriesClosedCessna 310 · Ft Lauderdale, FLOct 17, 1969 · N90L · Substantial damage NTSB MIA70A0034Accident · Serious injuriesClosedLockheed 18 · Golden Gate, FLOct 16, 1969 · N170L · Destroyed NTSB MIA70D0259Accident · No injuriesClosedCessna 170B · Pensacola, FLOct 11, 1969 · N1878C · Substantial damage NTSB MIA70D0175Accident · No injuriesClosedCessna 150H · Ft Lauderdale, FLOct 9, 1969 · N6647S · Substantial damage NTSB MIA70F0177Accident · No injuriesClosedPiper J3C-65 · Arcadia, FLOct 7, 1969 · N98083 · Substantial damage NTSB MIA70D0196Accident · No injuriesClosedPiper PA-28R · Boca Raton, FLOct 6, 1969 · N7626J · Substantial damage NTSB MIA70F0193Accident · No injuriesClosedCessna 177 · Clewiston, FLOct 5, 1969 · N3486T · Destroyed NTSB MIA70D0207Accident · No injuriesClosedCessna 150H · Pensacola, FLOct 4, 1969 · N22139 · Substantial damage NTSB MIA70A0029Accident · 3 fatalClosedBeech 95-C55 · Daytona Beach, FLOct 3, 1969 · N7982M · Destroyed NTSB MIA70A0025Accident · 3 fatalClosedBellanca 17-30 · Brooksville, FLSep 30, 1969 · N6673V · Destroyed NTSB MIA70A0024Accident · 2 fatalClosedBeech N35 · Cross City, FLSep 29, 1969 · N918JL · Destroyed NTSB MIA70F0185Accident · No injuriesClosedCessna 150H · Pensacola, FLSep 28, 1969 · N6587S · Substantial damage NTSB MIA70D0206Accident · No injuriesClosedGrumman 164 · Freeport, FLSep 28, 1969 · N589Y · Substantial damage NTSB MIA70D0166Accident · No injuriesClosedCessna 150G · Hollywood, FLSep 24, 1969 · N8648J · Destroyed NTSB MIA70D0187Accident · No injuriesClosedPiper PA-28R · Tampa, FLSep 20, 1969 · N7588J · Substantial damage NTSB MIA70F0172Accident · No injuriesClosedCessna 150J · Gainesville, FLSep 16, 1969 · N60725 · Substantial damage NTSB MIA70A0020Accident · 2 fatalClosedPiper PA-28R · Lake City, FLSep 16, 1969 · N2991R · Destroyed NTSB MIA70D0153Accident · No injuriesClosedCessna A188A · Pahokee, FLSep 11, 1969 · N3552Q · Substantial damage NTSB MIA70D0148Accident · No injuriesClosedCessna 150 · Tarpon Spgs, FLSep 9, 1969 · N3281J · Substantial damage NTSB MIA70A0018Accident · No injuriesClosedN.American 265-40 · Orlando, FLSep 9, 1969 · N85 · Substantial damage NTSB MIA70A0017Accident · 1 fatalClosedMaule M-4 · Lithia, FLSep 9, 1969 · N4144C · Destroyed NTSB MIA70D0141Accident · No injuriesClosedBeech C-18S · Naples, FLSep 4, 1969 · N6806C · Substantial damage NTSB MIA70F0152Accident · Minor injuriesClosedLuscombe 8A · Melbourne, FLSep 1, 1969 · N1251K · Destroyed NTSB MIA70F0154Accident · No injuriesClosedChampion 7FC · Merritt Is, FLAug 31, 1969 · N9883B · Substantial damage NTSB MIA70F0131Accident · No injuriesClosedErcoupe 415-D · Ft Lauderdale, FLAug 30, 1969 · N3271H · Substantial damage NTSB MIA70F0181Accident · No injuriesClosedCessna 177 · Orlando, FLAug 27, 1969 · N3258T · Substantial damage NTSB MIA70D0139Accident · Serious injuriesClosedCessna 188 · Mt Pleasant, FLAug 23, 1969 · N3556Q · Destroyed NTSB MIA70A0012Accident · No injuriesClosedDouglas DC-9 · Eglin Af Base, FLAug 18, 1969 · N895 · Substantial damage NTSB MIA70F0151Accident · No injuriesClosedLuscombe 8A · Sarasota, FLAug 17, 1969 · N2099K · Substantial damage