NTSB investigations, 2003, FL

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases, newest first

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
  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.

NTSB MIA03LA160Accident · No injuriesLimited investigationFinal reportCessna T210M · Hialeah, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal, fatigue failure of the crankshaft cheek, failure of the engine in cruise flight, and damage to the airplane during…Aug 10, 2003 · N86PH · Substantial damageNTSB MIA03CA158Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe failure of the student pilot to maintain directional control of the airplane during takeoff roll resulting in the aircraft departing the runway and incurring substantial damage.Aug 7, 2003 · N775SP · Substantial damageNTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.Aug 2, 2003 · N876RD · Substantial damageNTSB MIA03TA152Accident · No injuriesFinal reportBell BHT-206-B3 · Fort Myers, FLThe pilot's failure to adequately clear the right skid of obstructions which resulted in a dynamic rollover to the right during takeoff and damage to the helicopter.Jul 30, 2003 · N876M · Substantial damageNTSB 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.Jul 28, 2003 · UNREG · Substantial damageNTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.Jul 25, 2003 · N72AB · Substantial damageNTSB MIA03CA151Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2T · Crystal River, FLThe student pilot 's failure to maintain control while landing in crosswind which resulted in airplane departing the runway and incurring damage.Jul 25, 2003 · N643AM · Substantial damageNTSB MIA03LA146Accident · 1 fatalLimited investigationFinal reportSonerai Sonerai IIB · Lakeland, FLThe pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.Jul 20, 2003 · N224RB · DestroyedNTSB MIA03LA145Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Pierce, FLThe pilot's failure to maintain directional control of the airplane during landing roll resulting in collision with trees after the airplane departed the runway.Jul 20, 2003 · N5224Y · Substantial damageNTSB MIA03LA143Accident · No injuriesLimited investigationFinal reportCessna 172P · Plymouth, FLThe pilot's continue operation with known deficiencies (engine vibration) resulting in a partial loss of engine power during climb after takeoff and overrun of the runway during the aborted takeoff.Jul 20, 2003 · N52186 · Substantial damageNTSB MIA03LA189Accident · No injuriesLimited investigationFinal reportCessna 182P · Tampa, FLThe pilot's failure to attain the proper touchdown point which resulted in an undershoot.Jul 18, 2003 · N9913E · Substantial damageNTSB MIA03LA144Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLFailure of the student pilot of N864CP to judge the clearance between his airplane and the stationary N431ER while taxiing for takeoff which resulted in a ground collision.Jul 18, 2003 · N864CP · 2 aircraft · Substantial damageNTSB MIA03LA139Accident · Serious injuriesLimited investigationFinal reportSamual G. DaSilva Velocity · Sebastian, FLThe improper repair of the crankshaft by a FAA Certified Repair Station resulting in fatigue failure and subsequent total loss of engine power. A factor in the accident was the rough/uneven terrain encountered by the pilot during the landing roll in a field.Jul 1, 2003 · N51576 · Substantial damageNTSB MIA03LA138Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Belle Glade, FLThe inability of the pilot to maintain directional control of the airplane following a blown right main landing gear tire during the takeoff roll, resulting in the airplane rolling into soft terrain and subsequent nose over. A factor in the accident was the…Jul 1, 2003 · N82120 · Substantial damageNTSB MIA03FA135Accident · 2 fatalField investigationFinal reportCessna 414 · N. Fort Myers, FLThe failure of the pilot to maintain airspeed (Vs) following a total loss of engine power from the right engine due to fuel starvation, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees and terrain. Factors in the…Jun 26, 2003 · N749AA · Substantial damageNTSB MIA03LA134Accident · Serious injuriesLimited investigationFinal reportJohn L. Klein Marquart ChargerMA-5 · Pierson, FLSeparation of the elevator push/pull tube from the rear cockpit's control stick for undetermined reasons, which resulted in a loss of elevator control, an uncontrolled descent, and an impact with trees.Jun 25, 2003 · N707JK · Substantial damageNTSB 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…Jun 23, 2003 · N633DL · No damageNTSB MIA03CA132Accident · Minor injuriesData collectionFinal reportParsons Trainer · New Smyrna, FLFailure of the pilot to maintain control of the gyrocopter.Jun 23, 2003 · UNREG · Substantial damageNTSB MIA03LA127Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Taylor, FLThe in-flight encounter with turbulence during normal descent resulting in a serious injury to a passenger. A finding in the investigation was the seatbelt sign had been on for approximately 2 minutes at the time of the turbulence encounter.Jun 18, 2003 · N294SK · No damageNTSB MIA03CA125Accident · No injuriesData collectionFinal reportCessna 172S · Melbourne, FLThe pilot's improper flare and inadequate recovery from a bounced landing. Contributing factors were the pilot's failure to maintain directional control and his failure to execute a go-around.Jun 18, 2003 · N53352 · Substantial damageNTSB MIA03FA124Accident · 5 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FL**This case was revised 6/10/2005 and 2/24/2016. Refer to the public docket for this accident for details.** The failure of the pilot of N4903F, the Cessna 172, and the pilot of N759XA, the Cessna 182, to see and avoid each other while operating in Class E…Jun 17, 2003 · N4903F · 2 aircraft · DestroyedNTSB MIA03CA129Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kissimmee, FLThe inadequate supervision by flight instructor for his failure to prevent incorrect anti-torque pedal input by the student resulting in the helicopter yawing at touchdown. A factor in the accident was the incorrect anti-torque pedal input by the student…Jun 16, 2003 · N7185K · Substantial damageNTSB MIA03LA123Accident · Minor injuriesLimited investigationFinal reportZenith 601HDS · Immokalee, FLExcessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.Jun 14, 2003 · N601G · Substantial damageNTSB MIA03CA128Accident · Minor injuriesData collectionFinal reportKolb Mkiii · Bunnell, FLThe inadequate preflight inspection of the airplane by the pilot-in-command (pilot) for his failure to assure that the forward attachment of the right horizontal stabilizer was secured and safetied before flight resulting in rotation of the leading edge of…Jun 14, 2003 · UNREG · Substantial damageNTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…Jun 12, 2003 · N6981Z · Substantial damageNTSB MIA03FA120Accident · Minor injuriesField investigationFinal reportAerospatiale AS355F1 · Madison, FLThe pilot in command's diverted attention and loss of control while attempting to takeoff, which resulted in the main rotor blades being dragged, and the helicopter rolling over.Jun 11, 2003 · N217ES · Substantial damageNTSB MIA03LA118Accident · No injuriesLimited investigationFinal reportCessna 210E · Tallahassee, FLThe arching of the battery electric wire which was chaffing against the main steel braided fuel hose resulting in fire in the engine compartment.Jun 3, 2003 · N2328F · Substantial damageNTSB MIA03LA116Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLthe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with trees.Jun 1, 2003 · N9758G · Substantial damageNTSB MIA03CA113Accident · Minor injuriesData collectionFinal reportCessna 120 · Plant City, FLThe failure of the pilot to maintain control of the airplane resulting in it nosing over during the landing roll.May 27, 2003 · N76494 · Substantial damageNTSB MIA03LA114Accident · No injuriesLimited investigationFinal reportCessna 172E · Hastings, FLThe failure of the pilot to maintain control of the airplane resulting in in-flight collision with terrain.May 26, 2003 · N817T · Substantial damageNTSB MIA03LA112Accident · No injuriesLimited investigationFinal reportBeech C23 · Ormond Beach, FLThe pilot's inadequate preflight and his failure to refuel the airplane before departure resulting in the total loss of engine power due to fuel exhaustion and a hard landing during the subsequent forced landing.May 24, 2003 · N18936 · Substantial damageNTSB MIA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Meade, FLThew failure of the pilot to abort the takeoff after travelling past the estimated point of liftoff, and failure of the pilot to maintain airspeed during the initial climb resulting in inadvertent stall and uncontrolled descent with subsequent impact onto the…May 23, 2003 · N3921W · Substantial damageNTSB MIA03IA110Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…May 22, 2003 · N402DD · No damageNTSB MIA03LA109Accident · Serious injuriesLimited investigationFinal reportBill Darling Rans S9 · Green Cove Sprg, FLA loss of engine power for undetermined reasons.May 15, 2003 · N93WD · Substantial damageNTSB MIA03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Brooksville, FLThe in-flight collision with a Black Vulture resulting in substantial damage.May 11, 2003 · N7KH · Substantial damageNTSB MIA03CA107Accident · No injuriesData collectionFinal reportMichael Allen Brown RAF 2000 GTX · Punta Gorda, FLThe pilot's failure to maintain rotor speed during the takeoff which resulted in the gyrocopter descending and the main rotor impacting the ground, incurring damage.May 10, 2003 · N9DQ · Substantial damageNTSB MIA03CA106Accident · No injuriesData collectionFinal reportEnstrom 280C · Panama City Bch, FLThe pilot's failure to maintain adequate rotor rpm and altitude during takeoff which resulted in the helicopter impacting the water during a descent in an attempt to maintain rotor rpm.May 10, 2003 · N51752 · Substantial damageNTSB MIA03LA104Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Lantana, FLThe pilot/owner's failure to maintain rotor rpm which resulted in a loss of control. Contributing factors were high gross weight and high density altitude.May 5, 2003 · N2141U · Substantial damageNTSB MIA03LA101Accident · No injuriesLimited investigationFinal reportCessna 177-RG · Clearwater, FLThe pilot's failure to maintain directional control during landing roll resulting in the failure and separation of the right main landing gear, partial collapse of the nose landing gear, and substantial damage to the airplane.Apr 28, 2003 · N8015G · Substantial damageNTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.Apr 27, 2003 · N51898 · Substantial damageNTSB MIA03LA096Accident · No injuriesLimited investigationFinal reportCessna 172S · Melbourne, FLThe student pilot's improper throttle setting during the braking test, resulting in a collision with a parked airplane.Apr 12, 2003 · N52903 · Substantial damageNTSB MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…Apr 8, 2003 · N4549N · DestroyedNTSB MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…Apr 8, 2003 · N6037H · 2 aircraft · DestroyedNTSB MIA03LA085Accident · Minor injuriesLimited investigationFinal reportGhiles Philippe/American Ga MCR-01 VLA · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff after recognizing that the airplane did not become airborne at the calculated point down the runway. A contributing factor in the accident was the windshift during the takeoff roll resulting in a…Apr 7, 2003 · N6370X · Substantial damageNTSB MIA03CA093Accident · No injuriesData collectionFinal reportBoeing A75N1 · Lakeland, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane exiting the runway, impacting a runway light, and nosing over.Apr 4, 2003 · N2535R · Substantial damageNTSB MIA03LA092Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Pahokee, FLThe instructor's inadequate in-flight decision and his delay in taking remedial actions. Also causal was the student pilot's failure to maintain airspeed which resulted in a stall. Low altitude flight is a contributing factor.Apr 3, 2003 · N6488H · Substantial damageNTSB MIA03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Sarasota, FLA loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.Apr 1, 2003 · N4952J · Substantial damageNTSB MIA03LA089Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Lakeland, FLThe inadequate visual lookout of the pilot and the ground marshaller resulting in the ground marshaller being struck by the wing of the taxiing airplane and receiving serious injury.Apr 1, 2003 · N2652W · Minor damageNTSB MIA03CA086Accident · Minor injuriesData collectionFinal reportMathews Pegazai · Lakeland, FLThe failure of the pilot to maintain directional control and his inadequate compensation for wind.Apr 1, 2003 · N405BM · Substantial damageNTSB MIA03CA083Accident · No injuriesData collectionFinal reportCessna 190 · Lakeland, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control. A related factor was the crosswind.Mar 31, 2003 · N4413C · Substantial damage