NTSB investigations, FL
21 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 100)
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" = 100) 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 NYC07LA189Accident · Minor injuriesLimited investigationFinal reportStout Gordon Glasair III · Captiva, FLA loss of engine power for undetermined reasons.NTSB MIA07LA077Accident · 2 fatalLimited investigationFinal reportTerrence A. Sack Terrair Express · Lakeland, FLThe failure of the pilot to maintain airspeed while turning base to final which led to a stall. A contributing factor in the accident was the pilot's lack of recent experience.NTSB ANC06LA113Accident · Serious injuriesLimited investigationFinal reportSeales Protech PT-2B · Crestview, FLThe pilot's failure to correct for torque/p-factor during takeoff initial climb, which resulted in a loss of control and a collision with trees and a power line. Factors contributing to the accident were the pilot's lack of familiarity with the airplane, and…NTSB MIA05LA126Accident · 1 fatalLimited investigationFinal reportJSH Air LLC II Comp Air 7SLX · Winter Haven, FLThe abrupt steep pitch-up during the initial climb for undetermined reasons resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB ANC05FA030Accident · 2 fatalField investigationFinal reportBeech K35 · Leesburg, FLAn abrupt maneuver performed by the pilot at a low altitude, and his failure to maintain adequate airspeed, which precipitated an inadvertent stall and impact with terrain.NTSB MIA05FA050Accident · 2 fatalField investigationFinal reportCessna T337G · Lakeland, FLThe pilot's operation of the airplane with known deficiencies in equipment related to pitch, an abrupt pitch-up during the initial climb after takeoff for undetermined reasons and the failure of the pilot to maintain airspeed (Vs) resulting in inadvertent…NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…NTSB MIA03FA050Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA300/L · Golden Gate, FLThe airplane's entry into a near vertical descent for undetermined reasons, which resulted in a collision with terrain during the resultant descent.NTSB MIA00FA102Accident · 2 fatalField investigationFinal reportMcDonnell Douglas HU-600N · Miami, FLThe pilot's ostentatious display and in-flight decision to perform an abrupt low altitude pitch up maneuver (aerobatic flight). This resulted in the main rotor blades colliding with and separating the tail boom assembly while maneuvering, and the helicopters…NTSB MIA99LA039Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Fort Lauderdale, FLan abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.NTSB MIA94LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Naples, FLThe flight instructor's delayed reaction to take control of the helicopter. Contributing factors were the student pilot's improper use of cyclic and collective controls and his failure to release the flight controls to the flight instructor.NTSB MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.NTSB MIA92LA124Accident · No injuriesLimited investigationFinal reportCessna 172-P · Daytona Beach, FLThe delayed remedial action by the pilot-in-command (CFI) to the student's pushing the control yoke forward on short final approach.NTSB MIA88FA122Accident · No injuriesField investigationFinal reportBoeing 747-200 · Miami, FLAfter landing the Boeing 747-200 airliner, the captain increased the pitch attitude to 11 degrees nose up by pulling the control column aft. The tail struck the ground causing substantial damage. The Boeing airplane flight manual prescribes that the…NTSB MIA87FA191Accident · 2 fatalField investigationFinal reportRockwell 690A · Hilliard, FLRadar data indicated the acft climbed normally to 9,200 feet at which time some manuever was performed with the acft. The acft then entered a near vertical dive and the last radar hit was at 6,900 feet. Examination of the acft revealed it experienced an…NTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…NTSB MIA86FA100Accident · 3 fatalField investigationFinal reportBeech D-35 · Crystal Springs, FLWitnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued…NTSB MIA86FA027Accident · 2 fatalField investigationFinal reportParsons B/P Gyrocopter · Dunnellon, FLThe instructor plt who was not rated in helicopters or gyroplanes and had an expired instructors certificate was imparting instruction to a student plt in a 2 place homebuilt gyrocopter. When on downwind turn to base leg the student tipped the rotor disc…NTSB MIA85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLDuring a student trng flt the instructor pilot stated that he reduced throttle on takeoff at about 75 ft AGL, to simulate an engine failure. The student pilot pitched the nose of the acft up and the instructor pilot took over control of the acft, lowered the…NTSB MIA85FA071Accident · Serious injuriesField investigationFinal reportFuji LM-1 "NIKKO" · Odessa, FLThe acft collided with the ground in an acft parking area on the arpt after a low alt loop which was not completed prior to ground contact. The plt had made one low pass down the rwy in formation with another Fuji acft, a 2nd pass ended in an aileron roll,…NTSB MIA82DA085Accident · No injuriesFinal reportPiper PA-38-112 · Jasper, FLWhile on a cable inspection mission at 500 ft MSL, the engine began to lose power after the pilot had made an erratic maneuver to avoid birds. He initiated emergency procedures to restore power, but was unable. The nose gear failed and the aircraft flipped…