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 GAA18CA301Accident · No injuriesData collectionFinal reportEldridge George Skystar Kitfox SER 7 · Weippe, IDThe pilot’s failure to maintain a proper approach altitude, which resulted in a collision with a fence.NTSB GAA18CA288Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Marlborough, MAThe pilot’s improper decision to land on a runway that was too short for a safe landing and his subsequent failure to maintain directional control in tailwind conditions.NTSB GAA18CA260Accident · No injuriesData collectionFinal reportCessna 182 · Clarksville, TNThe pilot’s decision to land with a tailwind in variable crosswind and downdraft and updraft conditions on a wet runway, which resulted in a runway overrun.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.NTSB GAA18CA215Accident · No injuriesData collectionFinal reportPage Russell L Long EZ · Wakefield, VAThe pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist…NTSB GAA18CA128Accident · No injuriesData collectionFinal reportCessna 140 · Keller, TXThe pilot's inability to gain altitude normally in order to avoid a flock of ducks flying overhead during takeoff, which resulted in the airplane striking a fence.NTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA098Accident · No injuriesData collectionFinal reportSwearingen SA227 · Rock Springs, WYThe pilot's failure to maintain directional control while taxiing in gusting tailwind conditions.NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.NTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA18CA057Accident · No injuriesData collectionFinal reportKarpayev Vladyslav V RV-9 · Moab, UTThe pilot’s selection of an unsuitable taxiway, which resulted in the wings striking hidden fence posts.NTSB CEN18LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415 CD · Aurora, COThe failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.NTSB WPR18LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Redding, CAThe fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence.NTSB ANC18LA002Accident · No injuriesLimited investigationFinal reportFleetwood Jack Team Airbike · Ocean Springs, MSAn intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.NTSB ERA18LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Centre Hall, PAThe partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.NTSB GAA18CA021Accident · Minor injuriesData collectionFinal reportPiper PA32R · Block Island, RIThe pilot's use of an incorrect airspeed during landing, which resulted in a runway overrun.NTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.NTSB GAA17CA500Accident · No injuriesData collectionFinal reportBeech C23 · Rexburg, IDThe pilot's delayed decision to land the airplane with insufficient runway remaining after realizing the airplane wasn't climbing.NTSB GAA17CA495Accident · No injuriesData collectionFinal reportBell 206 · Minden, NVThe pilot’s failure to maintain helicopter control during landing due to a loss of tail rotor effectiveness.NTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.NTSB CEN17LA311Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Wellston, OHThe failure of a connecting rod small end bushing, which resulted in a loss of engine power.NTSB ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…NTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…NTSB WPR17LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Enumclaw, WAThe pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.NTSB WPR17LA159Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Van Nuys, CAAn improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…NTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.NTSB ERA17TA233Accident · No injuriesFinal reportLawrence O Nolte Zodiac CH650B · Dover, PAA total loss of engine power as a result of the loss of all electric fuel pumps due to a loss of electric power because of the installation of an improper battery on the airplane and the use of improper charging cables on the battery.NTSB GAA17CA367Accident · Minor injuriesData collectionFinal reportCessna 182 · San Martin, CAThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in an impact with a guard rail and post. Contributing to the accident was the pilot’s failure to ensure that sufficient fuel was onboard for nonlevel flight, which…NTSB GAA17CA361Accident · No injuriesData collectionFinal reportCessna 182 · Doniphan, MOThe pilot’s improper decision to take off with a known fuel leak, which resulted in a loss of engine power due to fuel exhaustion.NTSB GAA17CA343Accident · No injuriesData collectionFinal reportBurkhart Grob G103C · Boerne, TXThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway.NTSB GAA17CA341Accident · No injuriesData collectionFinal reportCessna 172 · Galena, IDThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.NTSB GAA17CA277Accident · No injuriesData collectionFinal reportCessna 172 · Boca Raton, FLThe student pilot’s failure to maintain directional control of the airplane while landing with a tailwind.NTSB GAA17CA276Accident · No injuriesData collectionFinal reportCessna 172 · Monument Valley, UTThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN17LA176Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Gypsum, KSA total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…NTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB GAA17CA185Accident · No injuriesData collectionFinal reportPipistrel Doo Ajdovscina Virus · Okmulgee, OKThe pilot’s failure to review the Federal Aviation Administration chart supplement before landing, which resulted in his landing on a closed runway and collision with a fence. Contributing to the accident was the airport’s failure to adequately mark the…NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.NTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.NTSB CEN17LA060Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Millersburg, OHThe pilot's improper in-flight fuel management and his failure to switch the fuel selector to the “both” position in accordance with the Before Landing checklist, which resulted in a loss of engine power due to fuel starvation.NTSB ERA17LA037Accident · No injuriesLimited investigationFinal reportAviat A 1B · Geneva, FLA partial loss of engine power due to debris in the No. 1 cylinder that damaged the spark plugs.NTSB ERA17LA034Accident · No injuriesLimited investigationFinal reportPiper PA32 · Bartow, FLA total loss of engine power during approach for reasons that could not be determined because engine examinations did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA17CA049Accident · No injuriesData collectionFinal reportAviat A-1C · Placerville, CAThe pilot’s failure to maintain directional control of the airplane during landing in gusty crosswind conditions.NTSB GAA17CA034Accident · No injuriesData collectionFinal reportYakovlev YAK · Tracy, CAThe pilot’s unstabilized approach and delayed application of full throttle for a go-around, which resulted in an uncontrolled descent.NTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB GAA17CA019Accident · No injuriesData collectionFinal reportPiper PA18 · Hanna, WYThe pilot's failure to maintain directional control during the landing roll in shifting wind conditions.