Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MIA68D0372Accident · No injuriesClosedPiper PA-22 · Gretna, FLDec 31, 1967 · N3332A · Substantial damage NTSB MIA68D0392Accident · No injuriesClosedBellanca 17-30 · Ft Lauderdale, FLDec 30, 1967 · N6687V · Substantial damage NTSB MIA68F0361Accident · No injuriesClosedCessna 310D · Vero Beach, FLDec 27, 1967 · N6959T · Substantial damage NTSB MIA68D0423Accident · No injuriesClosedErco 415-C · W.Palm Beach, FLDec 25, 1967 · N93779 · Substantial damage NTSB MIA68D0342Accident · No injuriesClosedCessna 172 · Merritt Isle, FLDec 24, 1967 · N1303F · Substantial damage NTSB MIA68D0323Accident · No injuriesClosedBeech V35 · Pompano Beach, FLDec 23, 1967 · N6257V · Substantial damage NTSB MIA68D0391Accident · No injuriesClosedCessna 150F · Venice, FLDec 20, 1967 · N8454G · Substantial damage NTSB MIA68A0056Accident · No injuriesClosedBell 47G · Miami, FLDec 20, 1967 · N2867B · Substantial damage NTSB MIA68D0358Accident · Minor injuriesClosedCessna 172 · Dunedin, FLDec 19, 1967 · N8074L · Destroyed NTSB MIA68F0371Accident · No injuriesClosedPiper PA-28 · Hialeah, FLDec 17, 1967 · N6801W · Substantial damage NTSB MIA68D0349Accident · No injuriesClosedCessna 150 · Miami, FLDec 17, 1967 · N4218U · Substantial damage NTSB MIA68F0341Accident · Minor injuriesClosedLuscombe 8A · Sarasota, FLDec 14, 1967 · N45934 · Destroyed NTSB MIA68D0322Accident · No injuriesClosedCessna 150 · Hollywood, FLDec 14, 1967 · N8851G · Substantial damage NTSB MIA68F0363Accident · No injuriesClosedCessna 150F · Bartow, FLDec 13, 1967 · N8758G · Substantial damage NTSB MIA68D0340Accident · No injuriesClosedCessna 210B · Kissimmee, FLDec 12, 1967 · N9656X · Substantial damage NTSB MIA68D0335Accident · No injuriesClosedAero Comdr 100 · Bunnell, FLDec 12, 1967 · N3899X · Substantial damage NTSB MIA68F0368Accident · No injuriesClosedPiper PA-22 · Deland, FLDec 9, 1967 · N4312A · Substantial damage NTSB MIA68F0350Accident · No injuriesClosedBeech C-45H · Miami, FLDec 7, 1967 · N9169Z · Substantial damage NTSB MIA68F0406Accident · No injuriesClosedBeech H18 · Jacksonville, FLDec 3, 1967 · N135W · Substantial damage NTSB MIA68D0329Accident · No injuriesClosedAero Comdr 500-B · Homestead, FLDec 3, 1967 · N6291X · Substantial damage NTSB MIA68D0444Accident · No injuriesClosedCessna 182 · Gainesville, FLDec 1, 1967 · N2369G · Substantial damage NTSB MIA68D0321Accident · No injuriesClosedPiper PA-24 · W.Palm Beach, FLNov 29, 1967 · N6308P · Substantial damage NTSB MIA68D0311Accident · No injuriesClosedCessna 170A · Tampa, FLNov 29, 1967 · N1111F · Substantial damage NTSB MIA68A0053Accident · 3 fatalClosedLear Jet 23 · Orlando, FLNov 29, 1967 · N690L · Destroyed NTSB MIA68A0051Accident · No injuriesClosedCurtiss C-46A · Key West, FLNov 28, 1967 · N75396 · Substantial damage NTSB MIA68A0052Accident · 4 fatalClosedMooney M20E · Tallahassee, FLNov 26, 1967 · N9253M · Destroyed NTSB MIA68A0050Accident · No injuriesClosedLockheed 18 · Ft Lauderdale, FLNov 25, 1967 · N24A · Substantial damage NTSB MIA68D0338Accident · No injuriesClosedCessna 210F · Opa Locka, FLNov 24, 1967 · N1966S · Substantial damage NTSB MIA68F0299Accident · No injuriesClosedPiper PA-22 · Melbourne, FLNov 23, 1967 · N3581A · Substantial damage NTSB MIA68D0337Accident · No injuriesClosedLake LA-4 · Miami, FLNov 17, 1967 · N1154L · Substantial damage NTSB MIA68D0298Accident · Minor injuriesClosedCessna 210 · Melbourne, FLNov 17, 1967 · N6100B · Substantial damage NTSB MIA68D0353Accident · No injuriesClosedMooney M20C · Jacksonville, FLNov 11, 1967 · N5951Q · Substantial damage NTSB MIA68D0319Accident · No injuriesClosedPiper PA-28 · W.Hollywood, FLNov 10, 1967 · N575CA · Substantial damage NTSB MIA68D0314Accident · No injuriesClosedPiper PA-23 · Immokalee, FLNov 10, 1967 · N3351P · Substantial damage NTSB MIA68F0310Accident · No injuriesClosedBeech C-18S · W.Hollywood, FLNov 9, 1967 · N5181 · Substantial damage NTSB MIA68D0334Accident · No injuriesClosedAero Comdr 100 · Bunnell, FLNov 8, 1967 · N3898X · Substantial damage NTSB MIA68F0313Accident · No injuriesClosedBeech B35 · Ft.Lauderdale, FLNov 7, 1967 · N5555K · Substantial damage NTSB MIA68A0044Accident · 1 fatalClosedLuscombe 8C · Temple Terrac, FLNov 5, 1967 · N28708 · 2 aircraft · Destroyed NTSB MIA68D0315Accident · No injuriesClosedBoeing A75N1 · Miami, FLNov 4, 1967 · N60925 · Substantial damage NTSB MIA68D0304Accident · No injuriesClosedCessna 150 · Davie, FLNov 2, 1967 · N8366J · Substantial damage NTSB MIA68D0297Accident · No injuriesClosedPiper PA-25 · Ero Beach, FLNov 2, 1967 · N6966Z · Substantial damage NTSB MIA68A0047Accident · Serious injuriesClosedConvair 880 · Jacksonville, FLNov 2, 1967 · N8494H · No damage NTSB MIA68F0269Accident · Serious injuriesClosedMooney M20E · Ft.Mccoy, FLOct 29, 1967 · N1302W · Substantial damage NTSB MIA68F0263Accident · Serious injuriesClosedCessna 120 · Venice, FLOct 29, 1967 · N1788V · Substantial damage NTSB MIA68D0316Accident · No injuriesClosedCessna 150F · Opa Locka, FLOct 29, 1967 · N8793G · Substantial damage NTSB MIA68D0275Accident · No injuriesClosedCessna 150 · Milton, FLOct 28, 1967 · N6615F · Substantial damage NTSB MIA68A0042Accident · 2 fatalClosedGlobe GC-1B · Titusville, FLOct 28, 1967 · N3337K · Destroyed NTSB MIA68F0317Accident · No injuriesClosedAero Comdr 500-B · Miami, FLOct 27, 1967 · N6291X · Substantial damage NTSB MIA68D0301Accident · No injuriesClosedPiper PA-28 · Opa Locka, FLOct 27, 1967 · N6773W · Substantial damage NTSB MIA68F0300Accident · No injuriesClosedCessna 150G · W Hollywood, FLOct 25, 1967 · N4744X · Substantial damage