Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 MIA67F0348Accident · Minor injuriesClosedPiper PA-28 · Ocala, FLDec 31, 1966 · N8139W · Substantial damage NTSB MIA67F0339Accident · No injuriesClosedPiper PA-22 · Ellenton, FLDec 31, 1966 · N5828D · Substantial damage NTSB MIA67D0357Accident · No injuriesClosedCessna 170A · Cocoa, FLDec 31, 1966 · N1734D · Substantial damage NTSB MIA67D0344Accident · Minor injuriesClosedCessna 150 · Miami, FLDec 28, 1966 · N4709X · Substantial damage NTSB MIA67F0365Accident · No injuriesClosedBeech B35 · Jacksonville, FLDec 26, 1966 · N5139C · Substantial damage NTSB MIA67F0343Accident · No injuriesClosedCessna 172 · Miami, FLDec 25, 1966 · N1480F · Substantial damage NTSB MIA67F0539Accident · No injuriesClosedChampion 7GCAA · Tallahassee, FLDec 24, 1966 · N8370V · Substantial damage NTSB MIA67D0368Accident · Minor injuriesClosedCessna 172 · Jacksonville, FLDec 24, 1966 · N1868Y · Substantial damage NTSB MIA67D0408Accident · No injuriesClosedCessna 150 · Havana, FLDec 22, 1966 · N8276S · Substantial damage NTSB MIA67D0336Accident · No injuriesClosedPiper PA-28 · Merritt Isle, FLDec 15, 1966 · N4548R · Substantial damage NTSB MIA67F0468Accident · No injuriesClosedPiper PA-24 · Pensacola, FLDec 14, 1966 · N6992P · Substantial damage NTSB MIA67F0337Accident · No injuriesClosedCessna 310D · Orlando, FLDec 13, 1966 · N1188 · Substantial damage NTSB MIA67F0352Accident · No injuriesClosedCessna 210C · Miami, FLDec 12, 1966 · N3639Y · Substantial damage NTSB MIA67D0375Accident · Minor injuriesClosedCessna 150F · Opa Locka, FLDec 11, 1966 · N1115T · Substantial damage NTSB MIA67F0366Accident · No injuriesClosedPiper PA-24 · Miami, FLDec 10, 1966 · N2276P · Substantial damage NTSB MIA67D0345Accident · No injuriesClosedCessna 150 · Arcadia, FLDec 8, 1966 · N7315X · Substantial damage NTSB MIA67I0066Incident · No injuriesClosedFairchild F-27 · Miami, FLDec 5, 1966 · N7531 · Minor damage NTSB MIA67F0322Accident · Serious injuriesClosedChampion 402 · W.Hollywood, FLDec 5, 1966 · N9964Y · Destroyed NTSB MIA67F0319Accident · No injuriesClosedPietenpol Camper · Homestead, FLDec 4, 1966 · N4632S · Substantial damage NTSB MIA67A0064Accident · 4 fatalClosedPiper PA-28 · St.Augustine, FLDec 3, 1966 · N8235W · Destroyed NTSB MIA67D0292Accident · No injuriesClosedCessna 150 · Hollywood, FLNov 25, 1966 · N8274S · Substantial damage NTSB MIA67A0060Accident · 1 fatalClosedCessna 172G · Davenport, FLNov 25, 1966 · N5791R · Destroyed NTSB MIA67F0323Accident · Minor injuriesClosedCessna 206 · Clearwater, FLNov 19, 1966 · N8061Z · Substantial damage NTSB MIA67D0331Accident · No injuriesClosedCessna 172 · Venice, FLNov 19, 1966 · N1761F · Substantial damage NTSB MIA67D0332Accident · No injuriesClosedCessna 150G · Melbourne, FLNov 18, 1966 · N3859J · Substantial damage NTSB MIA67F0329Accident · Serious injuriesClosedBoeing A75 · Florida City, FLNov 15, 1966 · N58226 · Substantial damage NTSB MIA67D0330Accident · No injuriesClosedSIAI FN-333 · Sorrento, FLNov 12, 1966 · N914NS · Substantial damage NTSB MIA67D0313Accident · No injuriesClosedCessna 172 · Opa Locka, FLNov 10, 1966 · N5359R · Substantial damage NTSB MIA67F0298Accident · No injuriesClosedLuscombe 8E · Iami, FLNov 9, 1966 · N1526B · Substantial damage NTSB MIA67F0358Accident · Minor injuriesClosedPiper PA-22 · Lake City, FLNov 8, 1966 · N7749D · Substantial damage NTSB MIA67D0309Accident · No injuriesClosedCessna 150 · Homestead, FLNov 7, 1966 · N5957T · Substantial damage NTSB MIA67F0289Accident · No injuriesClosedPiper PA-24 · Nna Maria, FLNov 6, 1966 · N7929P · Substantial damage NTSB MIA67D0311Accident · No injuriesClosedCessna 172 · Ft-Bassinger, FLNov 4, 1966 · N3582S · Substantial damage NTSB MIA67A0057Accident · 1 fatalClosedCessna 182 · Tarpon Spring, FLNov 4, 1966 · N1972X · Destroyed NTSB MIA67F0334Accident · No injuriesClosedCessna 150F · Gainesville, FLNov 2, 1966 · N8758G · Substantial damage NTSB MIA67F0273Accident · No injuriesClosedBeech H35 · Hernando, FLOct 30, 1966 · N5528D · Substantial damage NTSB MIA67D0288Accident · No injuriesClosedNavion A · Lake Wales, FLOct 30, 1966 · N8618H · Substantial damage NTSB MIA67D0271Accident · No injuriesClosedCessna 150 · Avon Park, FLOct 29, 1966 · N6016T · Substantial damage NTSB MIA67F0278Accident · No injuriesClosedCessna 210B · Winter Haven, FLOct 28, 1966 · N9598X · Substantial damage NTSB MIA67A0053Accident · No injuriesClosedBrantly B-2 · Prt Canaveral, FLOct 28, 1966 · N5904X · Substantial damage NTSB MIA67F0265Accident · No injuriesClosedCessna 182A · Lakeland, FLOct 25, 1966 · N5168D · Substantial damage NTSB MIA67F0244Accident · No injuriesClosedGlobe GC-1B · Brooksville, FLOct 23, 1966 · N80682 · Substantial damage NTSB MIA67F0308Accident · Serious injuriesClosedPiper J3C-65 · Naples, FLOct 22, 1966 · N3515K · Destroyed NTSB MIA67D0346Accident · No injuriesClosedCessna T-210F · Stuart, FLOct 21, 1966 · N6115R · Substantial damage NTSB MIA67F0314Accident · No injuriesClosedGlobe GC-1B · Crestview, FLOct 19, 1966 · N3283K · Substantial damage NTSB MIA67I0048IncidentClosedLockheed L-1049 · Miami, FLOct 18, 1966 · N6219C · Substantial damage NTSB MIA67F0257Accident · No injuriesClosedPiper PA-28 · Miami, FLOct 18, 1966 · N7599R · Substantial damage NTSB MIA67A0046Accident · 2 fatalClosedCessna 180 · Englewood, FLOct 16, 1966 · N2862A · Destroyed NTSB MIA67F0248Accident · No injuriesClosedCessna 310F · Tampa, FLOct 14, 1966 · N6757X · Substantial damage NTSB MIA67D0256Accident · Minor injuriesClosedMooney M20C · W.Palm Beach, FLOct 14, 1966 · N1215X · Substantial damage