NTSB investigations, 2002, FL

16 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases per year

19822026
NTSB investigations, 2002, FL per year, 1982–2026: 366 cases
198210
198323
198426
198524
198622
198716
198815
19899
199013
19917
199211
19937
199420
19958
199618
199712
199813
199915
200014
200110
200216
200310
200411
200512
20068
200716

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
  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 ATL03LA031Accident · No injuriesLimited investigationFinal reportBeech F-35 · Hollywood, FLThe pilot exceeded the design limits of the airplane which resulted in an in flight structural failure.Dec 25, 2002 · N4268B · Substantial damageNTSB MIA03LA033Accident · No injuriesLimited investigationFinal reportBeech 200 · Jacksonville, FLFailure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing.Dec 14, 2002 · N623VP · Substantial damageNTSB ATL03LA021Accident · No injuriesLimited investigationFinal reportCessna T210M · Lakeland, FLThe collapse of the main landing gear for undetermined reasons.Nov 25, 2002 · N6026N · Substantial damageNTSB ATL02IA165Incident · No injuriesIncident investigationFinal reportBeech 1900D · Tampa, FLThe improper service of the left main landing gear socket, resulting in fatigue failure of the left main landing gear socket assembly at the lower scissor attachment point.Aug 29, 2002 · N81533 · No damageNTSB ATL02IA155Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Tampa, FLThe failure of the left main landing gear retract cylinder support frame due to fatigue.Aug 10, 2002 · N388FE · Minor damageNTSB MIA02LA139Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · Santa Rosa Bch, FLThe separation of the canopy for undetermined reasons.Jul 24, 2002 · N1535G · Substantial damageNTSB ATL02LA130Accident · No injuriesLimited investigationFinal reportSikorsky S-55-QT · Orlando, FLFailure of the cyclic lateral control rod end bearing, and subsequent dynamic rollover.Jun 25, 2002 · N2300Z · Substantial damageNTSB MIA02TA109Accident · No injuriesFinal reportAgusta A119 · Okeechobee, FLthe fracture of one of the tail rotor blades as a result of fatigue cracking in the blade spar, and subsquent impact of the main rotor with the tailboom.Jun 12, 2002 · N911SL · Substantial damageNTSB ATL02LA095Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600N · Deland, FLThe pilot's failure to follow the FADEC malfunction checklist that resulted in the loss of rotor RPM, and the pilot's improper use of the flight controls during the precautionary landing that resulted in a hard landing. A factor was the malfunction of the…May 10, 2002 · N810LA · Substantial damageNTSB MIA02IA094Incident · No injuriesIncident investigationFinal reportBoeing B737-448 · Miami, FLInadequate maintenance by company maintenance personnel and failure to comply with manufacturer recommended maintence procedures (SB 737-55A1070R1), which resulted in an inflight inseparation of a section of the airplane's right hand elevator control tab. A…May 8, 2002 · EI-BXI · Minor damageNTSB MIA02LA089Accident · No injuriesLimited investigationFinal reportCessna 421C · Tampa, FLthe fracture of the landing gear upper barrel due to fatigue cracking, caused by improper machining after the barrel was assembled during the manufacturing process, resulting in damage to the airplane.Apr 25, 2002 · N237SM · Substantial damageNTSB ATL02LA066Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400A · Hastings, FLFatigue cracking in the most outboard splice bolt hole in the lower spar cap of the right wing. .Mar 26, 2002 · N3159G · Substantial damageNTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…Mar 6, 2002 · N75908 · Substantial damageNTSB ATL02LA055Accident · 1 fatalLimited investigationFinal reportKrejci S-51D · Port St. Lucie, FLThe pilots failure to maintain airspeed while maneuvering in an attempt to return to landing area (Emergency/ departure airport.) This resulted in an inadvertent stall and subsequent in-flight collision with terrain. Factor to the accident was a partial loss…Feb 26, 2002 · N51KK · Substantial damageNTSB MIA02LA060Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-V · West Palm Beach, FLThe flight crew's failure to follow preflight inspection/checklist procedures, which resulted in their failure to detect wooden sticks in the landing gear weight-on-wheel switches and their failure in flight to respond to crew alert messages to disarm the…Feb 14, 2002 · N777TY · Substantial damageNTSB ATL02LA035Accident · 1 fatalLimited investigationFinal reportSpringer Longbow 150 · Oak Hill, FLThe improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…Jan 10, 2002 · N150LB · Substantial damage