NTSB investigations, 1976, FL

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Cases per year

19622026
NTSB investigations, 1976, FL per year, 1962–2026: 10,190 cases
19627
19636
1964199
1965231
1966227
1967258
1968206
1969197
1970214
1971205
1972234
1973254
1974238
1975218
1976203
1977220
1978250
1979242
1980261
1981208
1982190
1983219
1984230
1985212
1986217
1987200
1988187
1989183
1990147
1991158
1992131
1993147
1994175
1995136
1996137
1997146
1998162
1999143
2000138
2001120
2002134
2003136
2004120
2005150
2006133
2007150
2008133
2009103
2010103
2011110
2012101
201391
2014101
201599
201696
201797
2018120
2019113
202092
202197
202282
202383
2024103
2025105
202682

Latest cases

Query with SQL
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\") = 1976
    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.

NTSB MIA77FLD24Accident · Minor injuriesClosedCessna 401 · Tampa, FLDec 31, 1976 · N111TV · DestroyedNTSB MIA77FLD23Accident · Minor injuriesClosedLet-Np-K L-13 · Clearwater, FLDec 31, 1976 · N65139 · Substantial damageNTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLDec 28, 1976 · N73840 · DestroyedNTSB MIA77DLA22Accident · No injuriesClosedBeech 35 · Ft.Pierce, FLDec 28, 1976 · N3314C · Substantial damageNTSB MIA77DLA12Accident · No injuriesClosedPiper PA-11 · Perry, FLDec 28, 1976 · N78698 · DestroyedNTSB MIA77FLD21Accident · No injuriesClosedGrum Amer AA-1B · St.Cloud, FLDec 27, 1976 · N6311L · Substantial damageNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLDec 25, 1976 · N22RL · DestroyedNTSB MIA77DLD20Accident · No injuriesClosedCessna 150 · Vero Beach, FLDec 24, 1976 · N18594 · Substantial damageNTSB MIA77FLA11Accident · No injuriesClosedCessna 188B · St Augustine, FLDec 17, 1976 · N53176 · DestroyedNTSB DCA77AA007Accident · Serious injuriesClosedConvair 880 · Miami, FLDec 16, 1976 · N5865 · Substantial damageNTSB MIA77FLD19Accident · No injuriesClosedPiper PA-32 · Lake Placid, FLDec 15, 1976 · N32038 · Substantial damageNTSB MIA77DLD18Accident · Serious injuriesClosedBalloon FF-6 · Temple Terrace, FLDec 12, 1976 · N2109F · Substantial damageNTSB MIA77DKT10Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLDec 11, 1976 · N19075 · Substantial damageNTSB MIA77DKT11Accident · No injuriesClosedPiper PA-24 · Sanibel Island, FLDec 10, 1976 · N9245P · Substantial damageNTSB MIA77FLA09Accident · No injuriesClosedCessna 177RG · Pensacola, FLDec 8, 1976 · N1521H · Substantial damageNTSB MIA77FA017Accident · 2 fatalClosedCessna 150J · Opa-Locka, FLDec 7, 1976 · N60153 · DestroyedNTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLDec 6, 1976 · N4240P · DestroyedNTSB MIA77DLD16Accident · No injuriesClosedPiper PA-28 · Rockledge, FLDec 4, 1976 · N6957J · Substantial damageNTSB MIA77FLA08Accident · No injuriesClosedCessna 402 · Jacksonville, FLDec 3, 1976 · N4012Q · Substantial damageNTSB MIA77DA015Accident · 2 fatalClosedCessna 337G · Summer Haven, FLDec 1, 1976 · N72459 · DestroyedNTSB MIA77DLD14Accident · No injuriesClosedPiper PA-18 · Verobeach, FLNov 29, 1976 · N13921 · Substantial damageNTSB MIA77FA014Accident · 1 fatalClosedPiper J3C · Copeland, FLNov 28, 1976 · N2228M · DestroyedNTSB MIA77FA013Accident · 2 fatalClosedPiper PA-28R · Tallahassee, FLNov 27, 1976 · N4615J · DestroyedNTSB MIA77DKT09Accident · Minor injuriesClosedPiper PA-25 · Boynton Beach, FLNov 26, 1976 · N9765P · Substantial damageNTSB MIA77DLA07Accident · No injuriesClosedCessna 210 · Jacksonville, FLNov 23, 1976 · N93100 · Substantial damageNTSB MIA77FLD17Accident · No injuriesClosedBirdman TL-1 · Deland, FLNov 18, 1976 · N27260 · Substantial damageNTSB MIA77FA010Accident · 3 fatalClosedPiper PA-31 · Tallahassee, FLNov 17, 1976 · N50BB · DestroyedNTSB MIA77DLA06Accident · No injuriesClosedPiper PA-24 · Lake City, FLNov 17, 1976 · N593RT · Substantial damageNTSB MIA76FA008Accident · 1 fatalClosedCessna 150L · Orlando, FLNov 16, 1976 · N7511G · DestroyedNTSB MIA77FA007Accident · Serious injuriesClosedFalcon Jet DA-20F · Naples, FLNov 12, 1976 · N27R · DestroyedNTSB MIA77FLD13Accident · Serious injuriesClosedStinson 108-3 · Brandon, FLNov 7, 1976 · N6159M · DestroyedNTSB MIA77DKT07Accident · No injuriesClosedAero Comdr 600S2R · Homestead, FLNov 5, 1976 · N1748S · Substantial damageNTSB MIA77FLD11Accident · No injuriesClosedCessna 150G · Riverview, FLNov 3, 1976 · N3209J · Substantial damageNTSB MIA77DLD12Accident · No injuriesClosedPiper J-3 · Venice, FLNov 1, 1976 · N87939 · Substantial damageNTSB MIA77DLD09Accident · No injuriesClosedGrum Amer AA-1B · Moss Bluff, FLOct 31, 1976 · N6329L · Substantial damageNTSB MIA77DLD08Accident · No injuriesClosedBaby Ace D · Deland, FLOct 30, 1976 · N39D · Substantial damageNTSB MIA77DLD10Accident · No injuriesClosedSchweizer SGS126 · Oviedo, FLOct 25, 1976 · N2631H · Substantial damageNTSB MIA76DLD07Accident · Minor injuriesClosedBowers NRI · Winter Haven, FLOct 24, 1976 · N3335 · Substantial damageNTSB MIA77FKT05Accident · No injuriesClosedHiller UH-12D · Lake Worth, FLOct 23, 1976 · N62401 · Substantial damageNTSB MIA77FLA05Accident · No injuriesClosedBeech B95 · Gainesville, FLOct 22, 1976 · N667T · Substantial damageNTSB MIA77FLD06Accident · Serious injuriesClosedNavion A · Geneva, FLOct 21, 1976 · N4915K · DestroyedNTSB MIA78DKT04Accident · Minor injuriesClosedBeech C35 · Key Largo, FLOct 15, 1976 · N2013D · Substantial damageNTSB MIA77FA003Accident · No injuriesClosedBoeing 727 · Miami, FLOct 13, 1976 · HI-212 · Substantial damageNTSB MIA77FA002Accident · 2 fatalClosedCessna 150J · Kissimee, FLOct 11, 1976 · N61083 · DestroyedNTSB MIA77FLD05Accident · Minor injuriesClosedBeech 35 · Merritt Island, FLOct 9, 1976 · N25R · Substantial damageNTSB MIA77DLA04Accident · No injuriesClosedEnstrom F-28 · Destin, FLOct 8, 1976 · N498H · Substantial damageNTSB MIA77FLD04Accident · No injuriesClosedCessna 310 · Sarasota, FLOct 5, 1976 · N5214A · Substantial damageNTSB MIA76DLD02Accident · No injuriesClosedEnstrom F-28A · Lake Placid, FLOct 4, 1976 · N162Q · Substantial damageNTSB MIA77FLD03Accident · No injuriesClosedCessna 150L · Merritt Island, FLOct 3, 1976 · N6868G · Substantial damageNTSB MIA77FLA01Accident · Serious injuriesClosedGrum Amer AA1-B · Lee, FLOct 3, 1976 · N1471R · Destroyed