NTSB investigations
316 cases where NTSB found Fence/fence post.
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022047')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022047')) 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 ERA20CA252Accident · Minor injuriesClass 4 · Data collectionFinal reportFurlong CA-6 · Manville, NJA loss of directional control on takeoff for undetermined reasons.NTSB WPR20CA214Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18A-135 · Marion, MTThe pilot's failure to maintain directional control of the airplane while landing in gusting wind conditions, which resulted in a runway excursion and collision with a fence.NTSB CEN20LA264Accident · No injuriesClass 3 · LimitedFinal reportMbb BK117 · Wooster, OHThe entanglement of construction fencing into the main rotor system, which necessitated a forced landing that resulted in substantial damage to the helicopter.NTSB WPR20CA195Accident · Minor injuriesClass 4 · Data collectionFinal reportCapella XLS · Liberty, UTThe pilot's failure to maintain clearance from a fence post during the initial climb.NTSB CEN20CA240Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer 269C · Sheffield, TXThe pilot's failure to maintain adequate clearance from a fence while hovering.NTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.NTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.NTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.NTSB CEN20CA085Accident · No injuriesData collectionFinal reportRobinson R44 · Marfa, TXThe pilot's failure to maintain clearance from a fence during low-altitude maneuvering.NTSB CEN20LA068Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Minot, NDThe pilot's failure to maintain clearance from fencing around the landing pad during landing, which resulted in the tail rotor contacting the fence.NTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.NTSB GAA20CA055Accident · No injuriesData collectionFinal reportCessna 172 · Augusta, GAThe student pilot's failure to attain sufficient airspeed to climb out of ground effect, which resulted in a descent, loss of directional control, runway excursion, and impact with a fence.NTSB GAA19CA575Accident · Minor injuriesData collectionFinal reportPiper J3C · Lander, WYThe pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.NTSB CEN19LA258Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172 · North Garden, VAA total loss of engine power due to the failure of the oil pump drive gear.NTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.NTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.NTSB GAA19CA366Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Yerington, NVThe pilot's failure to properly secure the airplane before hand propping it, which resulted in the unmanned airplane moving and colliding with a fence.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA19CA295Accident · No injuriesData collectionFinal reportPipistrel Alpha Trainer · Salida, COThe pilot's failure to replace the fuel cap after fueling, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing to a field and subsequent collision with a fence.NTSB CEN19LA157Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Palm City, FLA total loss of engine power due to fuel starvation.NTSB GAA19CA245Accident · No injuriesData collectionFinal reportErcoupe 415 C · Rosendale, WIThe pilot's selection of unsuitable terrain for an off-airport precautionary landing, which resulted in impact with a fence and a nose-over.NTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.NTSB GAA19CA224Accident · No injuriesData collectionFinal reportLuscombe 8 · Bremen, ALThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun, impact with a fence, and a nose-over.NTSB GAA19CA208Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Outlaw · Elizabeth, COThe pilot's failure to maintain adequate airspeed and his subsequent decision to initiate a turn, which resulted in the powered parachute’s descent and impact with a fence.NTSB GAA19CA196Accident · No injuriesData collectionFinal reportPiper PA32 · Lakeland, FLThe pilot's failure to maintain clearance from a fence post during taxi to parking.NTSB GAA19CA153Accident · No injuriesData collectionFinal reportCessna 172 · Princeton, NJA collision with deer on the runway while landing at night and the airport's lack of a complete perimeter fence.NTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.NTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.NTSB GAA19CA109Accident · No injuriesData collectionFinal reportBeech B19 · Los Angeles, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a fence.NTSB CEN19LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Adrian, MIThe airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.NTSB GAA19CA116Accident · No injuriesData collectionFinal reportBeech 24 · Edgewood, NMThe pilot's improper landing flare, which resulted in hard, bounced landing, loss of directional control, runway excursion, and impact with a fence and terrain during an attempted go-around.NTSB GAA19CA102Accident · No injuriesData collectionFinal reportBeech 36 · Sedona, AZThe pilot's failure to maintain the proper airspeed during landing, which resulted in the airplane landing too fast and too far down the runway to safely stop it.NTSB GAA19CA089Accident · No injuriesData collectionFinal reportPiper J4 · Forest, VAThe student pilot's improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.NTSB CEN18LA381Accident · No injuriesLimited investigationFinal reportPiper PA28 · Pagosa Springs, COThe student pilot's mismanagement of the fuel selector valve during the simulated forced landing demonstration and the flight instructor's inadequate supervision to ensure the fuel selector was properly set, which resulted in a loss of engine power and…NTSB GAA18CA542Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe student pilot's failure to maintain lateral control during the aborted landing.NTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.NTSB CEN18LA341Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Granbury, TXThe pilot’s failure to maintain directional control during a crosswind landing, which resulted in the airplane exiting the runway and impacting a ditch, tree, and fence.NTSB CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.NTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.NTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CEN18CA293Accident · Minor injuriesData collectionFinal reportJust JA30 Superstol · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during the initial climb and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18CA291Accident · No injuriesData collectionFinal reportQuad City Challenger · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA18LA195Accident · No injuriesLimited investigationFinal reportEagle DW1 · Ider, ALFatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.NTSB GAA18CA403Accident · No injuriesData collectionFinal reportRockwell 114 · Corsicana, TXThe pilot’s failure to maintain the runway heading during a soft-field takeoff with a tailwind, which resulted in a rejected takeoff.NTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.NTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.NTSB CEN18LA197Accident · Minor injuriesLimited investigationFinal reportFairchild M 62C(PT-23A) · Wichita, KSA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.