NTSB investigations, 2002, FL
16 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 23 |
| 1984 | 26 |
| 1985 | 24 |
| 1986 | 22 |
| 1987 | 16 |
| 1988 | 15 |
| 1989 | 9 |
| 1990 | 13 |
| 1991 | 7 |
| 1992 | 11 |
| 1993 | 7 |
| 1994 | 20 |
| 1995 | 8 |
| 1996 | 18 |
| 1997 | 12 |
| 1998 | 13 |
| 1999 | 15 |
| 2000 | 14 |
| 2001 | 10 |
| 2002 | 16 |
| 2003 | 10 |
| 2004 | 11 |
| 2005 | 12 |
| 2006 | 8 |
| 2007 | 16 |
Where
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.
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
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 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.NTSB 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.NTSB ATL03LA021Accident · No injuriesLimited investigationFinal reportCessna T210M · Lakeland, FLThe collapse of the main landing gear for undetermined reasons.NTSB 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.NTSB 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.NTSB MIA02LA139Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · Santa Rosa Bch, FLThe separation of the canopy for undetermined reasons.NTSB ATL02LA130Accident · No injuriesLimited investigationFinal reportSikorsky S-55-QT · Orlando, FLFailure of the cyclic lateral control rod end bearing, and subsequent dynamic rollover.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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. .NTSB 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…NTSB 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…NTSB 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…NTSB 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…