NTSB investigations, FL
88 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 7 |
| 1990 | 3 |
| 1991 | 10 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 3 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 8 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 4 |
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\" = 430)
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" = 430) 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 MIA07LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wimauma, FLThe failure of the pilot to maintain airspeed while maneuvering for a precautionary landing following a reported loss of engine power for undetermined reasons.NTSB ATL07CA094Accident · No injuriesData collectionFinal reportCessna C152 · Miami, FLThe pilot's loss of consciousness while on final approach to land, resulting in an uncontrolled descent, and a hard landing on the runway.NTSB MIA07LA059Accident · No injuriesLimited investigationFinal reportRobinson R-44-II · Miami, FLThe pilot's failure to maintain sufficient rotor rpm during an autorotative landing, which resulted in a hard landing and separation of the tailboom.NTSB MIA07CA040Accident · Serious injuriesData collectionFinal reportJim Garrison N11 · Titusville, FLThe failure of the pilot to abort the takeoff after becoming airborne during taxi testing, and the failure of the pilot to maintain airspeed after becoming airborne resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a tree.NTSB MIA07LA009Accident · 2 fatalLimited investigationFinal reportMike Smilee CGS Hawk II Arrow · Crystal Springs, FLThe failure of the non-rated pilot to maintain airspeed. A finding in the accident was a malfunction of the ignition switch.NTSB ANC06LA092Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Deland, FLThe flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…NTSB ANC06LA069Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Jacksonville, FLAn undetermined event during takeoff/initial climb, which resulted in an emergency landing after takeoff and substantial damage to the airplane.NTSB MIA06LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bunnell, FLThe failure of the pilot to perform a preflight inspection of the airplane resulting in departure with an inadequate oil supply, subsequent engine failure due to oil starvation, and damage to the airplane during a forced landing. Contributing to the accident…NTSB MIA06LA004Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff.NTSB MIA06CA003Accident · No injuriesData collectionFinal reportBeech 58 · Jacksonville, FLThe pilot's improper use of the normal brakes during the landing roll and his delay in performing a go-around resulting in an emergency descent/landing on grass past the departure end of the runway and subsequent collapse of the left main landing gear.NTSB MIA05LA080Accident · No injuriesLimited investigationFinal reportRobinson R44 · Homestead, FLThe CFI's inadequate supervision of the student during the instructional flight for his failure to stop an excessive rate of descent which resulted in a hard landing following a reported loss of engine power for undetermined reasons.NTSB MIA04IA056Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Fort Lauderdale, FLThe flight crews' inadvertent setting of the parking brake during flight resulting in the airplane being landed with the parking brake set and failure of all 8 main landing gear tires during the landing rollout.NTSB MIA03LA181Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Homestead, FLthe inadequate 100-hour inspection of the helicopter by other maintenance personnel who failed to discover that the landing gear dampers had low pressure, which resulted in ground resonance and subsequent substantial damage during a run-on landing.NTSB MIA03FA130Accident · Serious injuriesField investigationFinal reportBoeing 757-232 · Tampa, FLa torching of the right engine caused by an abnormally high flow fuel during engine start for undetermined reasons. The torching resulted in an unwarranted evacuation of the airplane and serious injuries to three passengers . A contributing factor in the…NTSB MIA02TA082Accident · Serious injuriesFinal reportAerospatiale SA319B Alouette III · Altoona, FLThe intentional operation of the helicopter with known deficiencies in equipment (inoperative normal brakes), and the pilot's improper use of the cyclic flight controls after the helicopter started rolling following touchdown.NTSB MIA02FA041Accident · Minor injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340-580STC · Sunny Isles Bch, FLThe inadequate dispatch of the airplane by company personnel prior to the first leg of the flight due to failure of company personnel to prepare a new flight release and weight and balance after considerable time on the ground with the engines operating. Also…NTSB MIA01LA212Accident · 2 fatalLimited investigationFinal reportPiper PA-32-260 · Key West, FLThe inadvertent disabling of the throttle in the idle position during a cockpit disturbance created when an armed hijacker forcibly attempted to cause the aircraft to fly to Cuba, resulting in a loss of controllability of power for sustainable flight and an…NTSB MIA01LA178Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Leesburg, FLThe pilot's failure to maintain a visual lookout while deploying the grappling hook in preparation for a banner pick up resulting in the cable wrapping around the stabilizer, subsequent loss of control during the banner drop (due to the cable moving forward…NTSB MIA01FA126Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilot's exceeding the forward center of gravity (CG) ) limits at the time of engine start, the inability of the pilot to control the airplane due to the exceeded CG limits, the failure of the pilot to abort the takeoff with sufficient runway remaining,…NTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…NTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…NTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…NTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.NTSB MIA00LA010Accident · No injuriesLimited investigationFinal reportCessna 150M · Bunnell, FLThe erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…NTSB MIA99LA179Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Wimauma, FLa passenger deplaning the airplane while the engine was running struck the propeller.NTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…NTSB DCA99IA058Incident · No injuriesIncident investigationFinal reportAirbus Industrie 300-600 · Miami, FLUncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…NTSB MIA99LA077Accident · Minor injuriesLimited investigationFinal reportLee S. Harvard LONG-EZ · Spring Hill, FLThe failure of the pilot to insure the canopy was closed prior to takeoff resulting in an aborted takeoff, overheating of the brakes, and a roll over when the aircraft was turned off the runway into the grass in an attempt to stop.NTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…NTSB MIA98LA148Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLfailure of the flight crew to maintain main rotor RPM during a landing touchdown, which resulted in the main rotor blades contacting the tailboom.NTSB ATL97LA086Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MDHC-369E · Okahumpka, FLThe failure of the crewmember to use the necessary safety equipment, and his subsequent fall from an elevated platform. A factor was the crewmember's distraction with an animal.NTSB MIA95IA238Incident · Minor injuriesIncident investigationFinal reportBoeing 737-400 · Fort Lauderdale, FLInadequate written maintenance procedures addressing steps to be followed in the event of a component failure during an engine wash. The emergency slides failed to deploy due to improper installation by company maintenance personnel.NTSB MIA95TA188Accident · No injuriesFinal reportMcDonnell Douglas H369 · Panama City, FLThe pilot-in-command's improper aft application of cyclic control during a simulated touchdown autorotation on landing flare touchdown, resulting in the main rotor blades colliding with the tail boom assembly. Contributing to the accident was the improper…NTSB MIA95IA134Incident · Serious injuriesIncident investigationFinal reportBoeing 727-227 · Brooksville, FLAn elderly passenger losing his balance as the aircraft operated in smooth air.NTSB MIA95LA032Accident · 1 fatalLimited investigationFinal reportCessna 172D · Miami, FLThe passenger committed suicide.NTSB MIA94LA195Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Merritt Island, FLFailure of the pilot to visually verify that the tow rope was not wrapped around any flight control surface and the inadvertent stall/spin. Contributing to the accident was the entanglement of the tow equipment with the rudder horn, rudder movement was…NTSB MIA94LA118Accident · No injuriesLimited investigationFinal reportCessna 310J · Ocala, FLFailure of the pilot to assure the generators were engaged before flight (failed to follow the checklist).NTSB MIA94IA043Incident · No injuriesIncident investigationFinal reportBoeing 767-322 · Miami, FLEmergency procedure initiated by an unqualified person.NTSB MIA93LA181Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Delray Beach, FLThe pilot-in-command's/flight instructor failure to communicate his intentions with the student pilot to effect a positive transfer of the flight controls, and improper handling of the airplane on landing roll out, resulting in an on ground collision with a…NTSB MIA92FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Naples, FLThe pilot-in-command's incapacitation due to an undetermined cardiovascular event which resulted in an uncontrolled descent into the ground.NTSB MIA92LA031Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Mariner · Ocala, FLThe pilot-in-command's improper use of collective control and throttle during recovery from an autorotation which resulted in loss of rotor RPM and a subsequent hard landing.NTSB MIA92LA027Accident · 1 fatalLimited investigationFinal reportBeech BE-35 · St. Petersburg, FLThe passenger's loss of balance resulting from a previous impairment.NTSB MIA92LA021Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Okeechobee, FLOperation by the owner/pilot-in-command with known deficiencies in equipment and fuel starvation due to a blocked fuel line.NTSB MIA91LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Palm Beach, FLTotal loss of engine power due to fuel exhaustion, and failure of the pilot to refuel before departure. Contributing to the accident was the pilot's lack of total experience in becoming lost/disoriented, and operation with known deficiencies in equipment.NTSB MIA91LA222Accident · Serious injuriesLimited investigationFinal reportHoffmeyer Moni Standard · Brooksville, FLIncapacitation of the pilot in command and inadvertent stall mush.NTSB MIA91IA199Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BA-3100 · Fort Myers, FLThe physiological incapacitation of the captain and his loss of consciousness due to a syncopal pleural event.