Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MIA69F0332Accident · No injuriesClosedBeech D18S · Jacksonville, FLDec 31, 1968 · N11141 · Substantial damage NTSB MIA69F0309Accident · No injuriesClosedPitts Spec S1C · Kendall, FLDec 29, 1968 · N203Z · Substantial damage NTSB MIA69D0297Accident · No injuriesClosedCessna 150H · Ft Lauderdale, FLDec 27, 1968 · N22448 · Substantial damage NTSB MIA69D0303Accident · Minor injuriesClosedCessna 177 · Merritt Islnd, FLDec 20, 1968 · N29394 · Substantial damage NTSB MIA69A0033Accident · 2 fatalClosedPiper PA-23 · Belle Glade, FLDec 20, 1968 · N5721Y · Destroyed NTSB MIA69F0324Accident · No injuriesClosedStinson 108-3 · Gainesville, FLDec 7, 1968 · N6771M · Substantial damage NTSB MIA69A0031Accident · 1 fatalClosedPiper PA-28 · Homestead, FLDec 7, 1968 · N7286F · Destroyed NTSB MIA69F0302Accident · Serious injuriesClosedPiper PA-28 · Ormond Beach, FLDec 2, 1968 · N8309R · Substantial damage NTSB MIA69D0284Accident · Minor injuriesClosedStinson 108 · Fort Myers, FLDec 2, 1968 · N8923K · Substantial damage NTSB MIA69D0285Accident · No injuriesClosedCessna 150H · Flamingo, FLNov 29, 1968 · N6540S · Substantial damage NTSB MIA69D0239Accident · No injuriesClosedCessna 150 · Pensacola, FLNov 28, 1968 · N8335J · Substantial damage NTSB MIA69A0028Accident · 2 fatalClosedStinson 108-3 · Ft.Lauderdale, FLNov 28, 1968 · N4174C · Destroyed NTSB MIA69F0280Accident · No injuriesClosedAmer Avco AA-1 · Dania, FLNov 24, 1968 · N221Y · Substantial damage NTSB MIA69F0279Accident · No injuriesClosedCessna 150F · West Hollywod, FLNov 23, 1968 · N3081X · Substantial damage NTSB MIA69D0278Accident · Minor injuriesClosedAero Comdr 560-E · Miami, FLNov 22, 1968 · N2788B · Substantial damage NTSB MIA69F0291Accident · No injuriesClosedBeech D95A · Orlando, FLNov 21, 1968 · N3729Q · Substantial damage NTSB MIA69A0069Accident · FatalClosedCurtis C C-46 · Miami, FLNov 21, 1968 · HP-344 · Substantial damage NTSB MIA69F0266Accident · No injuriesClosedCessna 150G · Opa Locka, FLNov 20, 1968 · N4636X · Substantial damage NTSB MIA69D0246Accident · Minor injuriesClosedCessna 205 · Belle Glade, FLNov 19, 1968 · N8211Z · Substantial damage NTSB MIA69D0265Accident · No injuriesClosedCessna 150 · W Palm Beach, FLNov 18, 1968 · N3742J · Substantial damage NTSB MIA69D0258Accident · No injuriesClosedCessna 182 · Silver Spring, FLNov 17, 1968 · N3154R · Substantial damage NTSB MIA69D0292Accident · No injuriesClosedAlon A-2 · Vero Beach, FLNov 9, 1968 · N5652F · Substantial damage NTSB MIA69F0328Accident · Serious injuriesClosedPiper PA-16 · Bartow, FLNov 8, 1968 · N5950H · Destroyed NTSB MIA69F0241Accident · Serious injuriesClosedCessna 172H · Chokoloskee, FLNov 8, 1968 · N2545L · Substantial damage NTSB MIA69D0237Accident · No injuriesClosedPiper PA-32 · Tallahassee, FLNov 8, 1968 · N3414W · Substantial damage NTSB MIA69F0282Accident · No injuriesClosedPiper PA-18 · Tallahassee, FLNov 7, 1968 · N3971Z · Substantial damage NTSB MIA69D0226Accident · No injuriesClosedCessna 150 · Melbourne, FLNov 4, 1968 · N50104 · Substantial damage NTSB MIA69F0381Accident · No injuriesClosedMooney M 20C · Smyrna Beach, FLNov 2, 1968 · N1903Y · Substantial damage NTSB MIA69D0260Accident · No injuriesClosedPiper PA-18 · Punta Gorda, FLNov 2, 1968 · N177T · Substantial damage NTSB UNK69X0100Accident · No injuriesClosedCessna 150 · Homestead, FLNov 1, 1968 · N4650X · Substantial damage NTSB MIA69D0238Accident · No injuriesClosedCessna 188 · Vero Beach, FLOct 30, 1968 · N9869V · Substantial damage NTSB MIA69D0256Accident · No injuriesClosedCessna 210 · Williston, FLOct 29, 1968 · N2333F · Substantial damage NTSB MIA69F0286Accident · Minor injuriesClosedCarver Copter · Brooksville, FLOct 27, 1968 · N54055 · Destroyed NTSB MIA69F0283Accident · No injuriesClosedCessna 182K · Live Oak, FLOct 27, 1968 · N2880R · Destroyed NTSB MIA69D0220Accident · No injuriesClosedPiper PA-28 · Belle Glade, FLOct 24, 1968 · N1887J · Substantial damage NTSB MIA69F0293Accident · No injuriesClosedPiper PA-24 · Jacksonville, FLOct 21, 1968 · N5380P · Substantial damage NTSB MIA69D0242Accident · Minor injuriesClosedCessna 210 · Marathon, FLOct 21, 1968 · N6866R · Substantial damage NTSB MIA69F0228Accident · 1 fatalClosedPitts S1C · Tampa, FLOct 20, 1968 · N6969 · Destroyed NTSB MIA69D0219Accident · Minor injuriesClosedSchleicher AS-K13 · Homestead, FLOct 19, 1968 · N1618 · Substantial damage NTSB MIA69A0023Accident · 4 fatalClosedBeech F35 · Deland, FLOct 15, 1968 · N5033B · Destroyed NTSB MIA69D0221Accident · No injuriesClosedCessna 172 · Daytona Beach, FLOct 14, 1968 · N46123 · Substantial damage NTSB MIA69F0340Accident · 1 fatalClosedGyroplane M-2 · Chuluota, FLOct 13, 1968 · N4772S · Destroyed NTSB MIA69A0022Accident · No injuriesClosedCessna 310C · Lantana, FLOct 13, 1968 · N1721H · 2 aircraft · Substantial damage NTSB MIA69F0294Accident · Minor injuriesClosedCessna 150F · Titusville, FLOct 12, 1968 · N6482F · Substantial damage NTSB MIA69F0281Accident · Minor injuriesClosedPiper PA-28 · Pensacola, FLOct 10, 1968 · N6698W · Substantial damage NTSB MIA69D0223Accident · No injuriesClosedBell 47G2A1 · Haines City, FLOct 5, 1968 · N1158W · Substantial damage NTSB MIA69A0018Accident · 3 fatalClosedCessna 177 · Miami, FLOct 5, 1968 · N29407 · 2 aircraft · Destroyed NTSB MIA69D0287Accident · No injuriesClosedCessna 182 · Jacksonville, FLOct 4, 1968 · N42765 · Substantial damage NTSB MIA69F0224Accident · No injuriesClosedBeech 35 · Opa Locka, FLOct 3, 1968 · N80433 · Substantial damage NTSB MIA69D0240Accident · Serious injuriesClosedCessna 182 · Bonifay, FLSep 28, 1968 · N8510T · Substantial damage