NTSB investigations, FL
366 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
Open the mapLatest 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 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 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 NYC08LA060Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Plant City, FLA loss of rotor drive due to excessive slack and breakage of the drive belts. Contributing to the accident was the pilot departing in the helicopter after the rotor engagement time during engine start exceeded the time outlined in the pilot's operating…NTSB NYC08LA052Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gainesville, FLThe pilot's failure to follow the published emergency procedure. Contributing to the accident was a malfunction of the clutch assembly.NTSB MIA07LA148Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lakeland, FLThe failure of company maintenance personnel to replace the tail rotor drive shafts following tail rotor blade damage in 1999, the failure of maintenance personnel to replace the tail rotor drive shafts in 2004, following their knowledge that the tail rotor…NTSB NYC07CA190Accident · No injuriesData collectionFinal reportAckert Dakota Hawk DH23 · Sebring, FLPreexisting cracking of the landing gear tubing.NTSB MIA07LA123Accident · No injuriesLimited investigationFinal reportLarry J. Cook Lancair 320 · Destin, FLThe separation of a portion of a propeller blade due to fatigue cracking which initiated in an area of corrosion that was not detected during propeller overhaul 10 flight hours before the accident.NTSB NYC07IA164Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Orlando, FLThe mechanic's failure to secure the right engine cowling fasteners. Contributing to the incident was the pilot's inadequate preflight inspection.NTSB MIA07LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lantana, FLSeparation of a landing gear hydraulic line at the fitting for undetermined reasons.NTSB MIA07LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Fort Lauderdale, FLThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear.NTSB SEA07LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ocala, FLThe failure of the left main axle during the landing roll, which resulted in the collapse of the left main landing gear. A crosswind on the landing runway was a factor.NTSB DEN07FA079Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ponte Vedra Bch, FLthe mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…NTSB MIA07IA052Incident · No injuriesIncident investigationFinal reportLiberty Aerospace XL-2 · Ormond Beach, FLThe improper manufacturing of the nose undercarriage leg by the vendor, and the inadequate surveillance of the vendor by the airplane manufacturer.NTSB MIA07LA049Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369FF · Placida, FLThe in-flight separation of the tail rotor pitch change control rod and bellcrank during takeoff-initial climb.NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.NTSB MIA07LA039Accident · No injuriesLimited investigationFinal reportCessna 177 · Carrabelle, FLThe failure of maintenance personnel to detect corrosion and a fatigue crack during the last annual inspection.NTSB MIA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Tampa, FLThe inadequate design of the engine mount by the manufacturer, resulting in fatigue failure at the actuator attach foot and partial collapse of the nose landing gear.NTSB MIA07LA041Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Immokalee, FLThe failure of the glider towing "weak link," for undetermined reasons, at an inadequate altitude to effect a normal landing, resulting in a hard landing.NTSB MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB MIA07LA013Accident · Minor injuriesLimited investigationFinal reportWinter J.T/Johnson Kitfox III · Southwest Ranch, FLThe owner/builder's improper maintenance/installation of the propeller which resulted in a propeller blade coming loose and separating from the hub.NTSB MIA06LA123Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLThe pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.NTSB MIA06FA120Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Fort Pierce, FLthe pilot’s loss of aircraft control during the initial climb which was precipitated by the sudden loss of thrust and increase in drag from the right engine, and the pilot’s failure to adhere to the published emergency procedures regarding the position of the…NTSB MIA06FA117Accident · 1 fatalField investigationFinal reportBeech 65-A90-1 · Tampa, FLThe poor in-flight planning decision by the captain for his failure to establish the airplane on a stabilized approach for a forced landing, resulting in the airplane landing on a taxiway near the departure end of the runway. Contributing to the accident were…NTSB MIA06LA126Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Navarre, FLThe inadequate manufacturing of the plates of the tail rotor tension-torsion bar assembly resulting in fatigue failure.NTSB MIA06LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Fort Myers, FLThe flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…NTSB MIA06LA057Accident · No injuriesLimited investigationFinal reportCessna 525A · Tampa, FLFailure of both the left main and auxiliary brake lines due to fatigue cracking, rendering directional control impossible. A contributing factor in this accident was the airport sign concrete pad.NTSB DCA06MA010Accident · 20 fatalClass 1 · MajorFinal reportGrumman G-73T · Miami, FLThe in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…NTSB MIA06LA002Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Destin, FLThe inadequate design of the engine mount which led to cracking of the mount resulting in a loss of directional control and collapse of the nose landing gear. A contributing factor was the failure of maintenance personnel to comply with a service bulletin to…NTSB MIA05LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Orlando, FLThe manufacturer's defective wheel brake assembly design and a leaking wheel brake, resulting in an overheated brake assembly and a wheel fire during an aborted takeoff.NTSB MIA05IA132Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Titusville, FLThe pilot's continued operation of the airplane with known intermittent deficiencies of the electric pitch trim switch, resulting in a mis-trim condition of the airplane (nose-up), and subsequent hard landing on the nose landing gear causing it to collapse. A…NTSB MIA05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Myers, FLInadequate maintenance and repair of the engine top cowling by company maintenance personnel, resulting in failure and separation of the cowling in flight.NTSB MIA05LA104Accident · Minor injuriesLimited investigationFinal reportBritish 167 StrikemasterMK83 · Boca Raton, FLThe delay by the pilot-in-command to abort the takeoff after recognizing excessive elevator control forces for undetermined reasons during the landing roll, resulting in the on-ground collision with a fence.NTSB ATL05FA079Accident · 2 fatalField investigationFinal reportNorth American SNJ-6 · Kissimmee, FLThe failure of the outboard right-wing lower attachment bracket due to fatigue cracking and the subsequent in-flight separation of the right wing assembly.NTSB MIA05LA086Accident · Serious injuriesLimited investigationFinal reportFrank D. Amador Searey · Green Cove Spr, FLThe airplane builder's improper installation of the left rudder control cable, which resulted in the cable becoming jammed, a loss of directional control during takeoff, and the airplane departing the runway and impacting a tree.NTSB MIA05LA066Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe improper installation and securing of the elevator trim tab push-rod attaching hardware by maintenance personal resulting in the rod disconnecting and a partial separation of the right elevator in flight.NTSB ANC05FA039Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Dunnellon, FLThe improper installation of the bolt that connects the throttle linkage to the fuel control arm by an unknown maintenance person, which resulted in a loss of the bolt, a loss of engine rpm control, and subsequent forced landing and collision with trees.NTSB ANC05LA026Accident · No injuriesLimited investigationFinal reportCessna 411A · Hollywood, FLThe failure of the right main landing gear locking mechanism during the landing roll, which resulted in the collapse of the right main landing gear.NTSB MIA05LA046Accident · 1 fatalLimited investigationFinal reportCessna 172M · Orlando, FLThe failure of the CFI to initiate a precautionary landing after noticing zero oil pressure with corresponding oil temperature increase, resulting in total loss of engine power due to oil exhaustion. A contributing factor in the accident was the failure of…NTSB MIA05LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, FLThe improper flare by the pilot in command resulting in a hard landing, Restricted movement of the throttle was a contributing factor.NTSB MIA04GA117Accident · 1 fatalFinal reportBell 47G-5 · Bunnell, FLThe pilot's continued flights and inadequate inspections after repeated tail rotor guard ground strikes due to improper flaring, which resulted in an in-flight failure of tail rotor drive shaft components, a loss of control, and the helicopter crash.NTSB MIA04FA115Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Miami, FLThe failure of company maintenance personnel to secure the push/pull tube to the left lug of the non-rotating portion of the swashplate assembly following maintenance, and the inability of the pilot to control the helicopter resulting in the in-flight…NTSB ATL04LA148Accident · No injuriesLimited investigationFinal reportCessna 401B · Naples, FLThe fracture of the right landing gear down lock stud which resulted in the right main landing gear collapse during landing roll.NTSB MIA04LA092Accident · 1 fatalLimited investigationFinal reportNorth American T-28B · Wesley Chapel, FLThe pilot's failure to verify security of the left engine cowling and its subsequent separation in-flight and collision with the vertical stabilizer resulting in the loss of aircraft control.NTSB MIA04IA088Incident · No injuriesIncident investigationFinal reportBeech A36 · Daytona Beach, FLImproper maintenance/installation by the propeller overhaul/repair facility, which resulted in stress related fatigue and the eventual separation of the propeller pitch change pin.NTSB MIA04LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · N. Lauderdale, FLThe erratic operation of the pitot-static system associated flight instruments due to water contamination, and the pilot's failure to take the appropriate corrective actions.NTSB IAD04LA016Accident · 2 fatalLimited investigationFinal reportPilatus P3-05 · Edgewater, FLThe delamination of the no. 2 connecting rod bearing for undetermined reasons, resulting in a total loss of engine power. A factor in the accident was the pilot's inability to complete a successful forced landing due to oil on the windscreen, and smoke and…NTSB MIA04LA062Accident · No injuriesLimited investigationFinal reportBeech BE90 · Fort Lauderdale, FLThe inadequate inspection of the landing gear system by company maintenance personnel resulting in a crack in the left main landing actuator mount going undetected and collapse of the left landing gear during landing roll when the actuator attachment failed.NTSB MIA04LA058Accident · 1 fatalLimited investigationFinal reportOrtmayer/Parson none · Bunnell, FLThe owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.NTSB ANC04IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-300 ER · Miami, FLThe inadequate quality of material in the main landing gear bogie pivot pin, which resulted in a premature fracture of the pin.NTSB MIA04LA004Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-112 · Tampa, FLAn intermittent fault with the airplane's Brake Steering Control Unit (BSCU) for undetermined reasons, which resulted in a momentary loss of brakes and steering, and a serious injury to a flight attendant during the resultant sudden stop during taxi for…NTSB MIA03IA168Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Miami, FLThe failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…NTSB MIA03LA150Accident · 1 fatalLimited investigationFinal reportTurkan Delta Wing Kite Trik · Odessa, FLThe pilot's improper assembly and failure to connect a bolt following an attempted modification that resulted in airframe malfunction, and uncontrolled descent, and an impact with the ground.