NTSB investigations, 2000, FL
14 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\") = 2000
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") = 2000 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 MIA01LA040Accident · No injuriesLimited investigationFinal reportCessna 421B · Pensacola, FLThe failure of the left main landing gear scissors washer during taxi for takeoff, and collapse of the left main landing gear. A factor in the accident was the failure of unknown maintenance personnel to comply with a manufacturers service letter concerning…NTSB ATL01LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Merritt Island, FLMaintenance personnel failure to properly install engine cowling fasteners, which allowed the engine cowling to separate in flight.NTSB MIA01FA029Accident · 1 fatalField investigationFinal reportAirbus Industrie A300B4-605R · Miami, FLThe failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…NTSB MIA00TA200Accident · No injuriesFinal reportHughes 369D · Destin, FLimproper maintenance inspection of the tail rotor by maintenance personnel and improper preflight inspection of the tail rotor by the pilot, which resulted in worn elastomeric bearings being continued in service, resulting in failure of the tail rotor…NTSB ATL00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Key West, FLA landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.NTSB MIA00IA186Incident · No injuriesIncident investigationFinal reportGrumman G-73T · Watson Island, FLthe overload separations of the control yoke on the captain's side.NTSB MIA00LA170Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Fort Pierce, FLAn in-flight separation of a tail rotor blade tip weight resulting in tail rotor assembly imbalance and separation due to the installation of an unapproved rotor blade by company maintenance personnel, and the subsequent collision with trees during an…NTSB MIA00LA134Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Lakeland, FLThe disconnection of the tail rotor drive shaft and subsequent lack of tail rotor control. Contributing factors were the worn drive shaft splines and the pilots' failure to apply collective on the touchdown resulting in a hard landing and subsequent roll over.NTSB MIA00LA131Accident · Minor injuriesLimited investigationFinal reportMcCan Velox REV II · Mulberry, FLThe bending overstress separation of the elevator pitch control rod for undetermined reasons. This resulted in an in-flight loss of control, bail out, and subsequent in-flight collision with terrain.NTSB MIA00LA137Accident · Minor injuriesLimited investigationFinal reportWalden A. Cooper Pitts S1S · Daytona Beach, FLCollapse of the tail wheel to the right during landing rollout when the forward attach bolt sheared for undetermined reasons. This resulted in the aircraft's rudder deflecting to the right, the pilot losing directional control, and the aircraft running off…NTSB MIA00IA128Incident · No injuriesIncident investigationFinal reportDassault DA-20 · Opa Locka, FLThe failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…NTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.NTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.NTSB ATL00IA035Incident · No injuriesIncident investigationFinal reportCessna CE-560 · Key Largo, FLThe malfunction of the nose gear locking mechanism for undetermined reason.