NTSB investigations, 2022, FL

30 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2022, FL per year, 2008–2026: 778 cases
200850
200943
201048
201150
201256
201345
201447
201546
201655
201750
201865
201939
202026
202121
202230
202323
202437
202529
202618

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\") = 2022
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA23FA079Accident · 3 fatalClass 3 · FieldFinal reportPiper PA28 · Venice, FLThe pilot’s spatial disorientation during takeoff in dark night visual meteorological conditions, which resulted in his failure to maintain a positive rate of climb and a subsequent descent into the water.Dec 4, 2022 · N4676F · Substantial damageNTSB ERA23FA060Accident · 1 fatalClass 3 · FieldFinal reportDetrick Donald G Detrick DA-2 · Oak Hill, FLThe student pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a tree.Nov 15, 2022 · N4307Q · Substantial damageNTSB ERA23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Lake Worth, FLA loss of engine power for reasons that could not be determined.Oct 23, 2022 · N39628 · Substantial damageNTSB ERA23FA023Accident · 2 fatalClass 3 · FieldFinal reportPeryera Adventura II · Miramar, FLThe pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.Oct 17, 2022 · N32856 · Substantial damageNTSB ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.Oct 13, 2022 · N3885X · Substantial damageNTSB ERA23LA011Accident · Serious injuriesClass 3 · LimitedFinal reportBell Textron Canada 505 · Fort Myers, FLThe pilot’s execution of a landing approach with a right, quartering tailwind, low forward airspeed, and high power demand that, when combined, resulted in a loss of tail rotor effectiveness and helicopter control.Oct 8, 2022 · N5DF · Substantial damageNTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.Aug 24, 2022 · N263MX · Substantial damageNTSB ERA22LA382Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7AC · Clermont, FLThe pilot’s inability to maintain directional control while landing due to a worn tailwheel locking mechanism, which resulted in a runway excursion and collision with terrain.Aug 21, 2022 · N44FC · Substantial damageNTSB ERA22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Wauchula, FLThe pilot’s failure to maintain directional control after landing. A contributing factor was a degraded left main landing gear wheel assembly.Aug 1, 2022 · N119ED · Substantial damageNTSB ERA22FA344Accident · 2 fatalClass 3 · FieldFinal reportHarvey J Brock Tango 2 · Melrose, FLA loss of control for undetermined reasons.Jul 30, 2022 · N8680G · Substantial damageNTSB ERA22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Mariner · Hollywood, FLInadequate maintenance of the helicopter’s tail rotor blades, which resulted in a failure of the tail rotor drive system, and an inflight loss of yaw control from which the flight instructor was unable to recover.Jul 27, 2022 · N42WC · Substantial damageNTSB ERA22LA329Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Plant City, FLA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight fuel planning.Jul 21, 2022 · N84423 · Substantial damageNTSB ERA22LA322Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV10 · Palatka, FLTotal loss of engine power due to the improper installation of an electronic ignition system connector plug.Jul 18, 2022 · N910BW · Substantial damageNTSB ERA22LA433Accident · No injuriesClass 4 · LimitedFinal reportEaster William C M-1 · Okeechobee, FLThe premature placement of an airport runway closure marker short of the runway, which resulted in the airplane’s collision with the marker during the landing approach. Contributing was the pilot’s inability to see the marker due the nose-high attitude of the…Jul 16, 2022 · N150MM · Substantial damageNTSB ERA22LA299Accident · Serious injuriesClass 4 · LimitedFinal reportArnold J/Jones D L AIR CAM · Sebring, FLThe pilot’s loss of control during landing.Jul 3, 2022 · N6272Z · Substantial damageNTSB ERA22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · St. Petersburg-Clearwater, FLThe pilot’s inability to stop the airplane on the available runway, which resulted in a runway excursion and collision with an airport perimeter fence.May 23, 2022 · N47BP · Substantial damageNTSB ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…May 3, 2022 · N6413B · DestroyedNTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.Apr 26, 2022 · N281SP · Substantial damageNTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.Apr 18, 2022 · N8891N · Substantial damageNTSB ERA22LA192Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Cedar Key, FLThe pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.Apr 18, 2022 · N919AC · Substantial damageNTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…Apr 16, 2022 · N19KW · Substantial damageNTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.Mar 29, 2022 · N22LV · Substantial damageNTSB ERA22LA172Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Melbourne, FLA loss of engine power due to oil starvation as a result of the failure of the No. 3 crankshaft journal bearing.Mar 29, 2022 · N5067W · Substantial damageNTSB ERA22LA159Accident · No injuriesClass 3 · LimitedFinal reportDwyer Michael D Q · Spring Hill, FLThe pilot’s improper modification of the pull starter motor, which resulted in its failure and the subsequent loss of engine power.Mar 17, 2022 · N3QP · DestroyedNTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…Mar 9, 2022 · N182XT · DestroyedNTSB ERA22LA142Accident · 2 fatalClass 3 · LimitedFinal reportVans RV-12IS · Big Pine Key, FLThe pilot’s inadequate preflight and in-flight weather planning and his improper decision to continue visual flight rules flight into an area of limited visibility in moderate precipitation, which resulted in a loss of airplane control due to spatial…Feb 27, 2022 · N123RR · DestroyedNTSB ERA22LA119Accident · No injuriesClass 4 · LimitedFinal reportGreat Lakes 2T-1A-2 · Naples, FLThe biplane pilot’s inadequate visual lookout, which resulted in an on-ground collision with another airplane while taxiing.Feb 11, 2022 · N87G · 2 aircraft · Minor damageNTSB ERA22LA112Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195 · Palm Coast, FLThe pilot’s inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Jan 31, 2022 · N597K · Substantial damageNTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.Jan 20, 2022 · N5125X · Substantial damageNTSB ERA22LA107Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Winter Haven, FLThe pilot receiving instruction’s failure to maintain airspeed during a turn, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor’s failure to…Jan 12, 2022 · N88509 · Substantial damage