NTSB investigations

204 cases where NTSB found Airport facilities/design.

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\", '030170'))
  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 CHI08CA198Accident · No injuriesData collectionFinal reportRockwell S2R · Carthage, ILThe pilot failed to maintain directional control during the takeoff roll. Contributing to the accident were the uneven runway, the runway edge, and the cornfield.Jul 18, 2008 · N8466V · Substantial damageNTSB LAX08CA225Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's misjudged altitude and distance, which resulted in the airplane's failure to attain the proper touchdown point and a landing overrun. Contributing to the accident were trees and the short runway.Jul 9, 2008 · N300DF · Substantial damageNTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.Jul 8, 2008 · N653DF · Substantial damageNTSB DEN08LA121Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Point Lookout, MOA fuel flange seal leak and water in the fuel resulting in a loss of engine power during takeoff. Contributing to the accident was an inadequate preflight.Jul 6, 2008 · N53661 · Substantial damageNTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.Jul 6, 2008 · N6715X · Substantial damageNTSB LAX08CA210Accident · No injuriesData collectionFinal reportCessna TU206G · Coeur d'Alene, IDThe pilot's failure to maintain proper runway alignment and clearance from a large rock on the side of the runway. Contributing to the accident was the failure of the pilot to maintain the runway environment of his private strip clear of obstructions.Jul 1, 2008 · N4776U · Substantial damageNTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.Jun 29, 2008 · N83056 · Substantial damageNTSB CHI08CA173Accident · Minor injuriesData collectionFinal reportBeech A23A · Sheboygan, WIThe pilot's improper fuel management that led to fuel starvation and the loss of engine power. Contributing to the accident was the drainage ditch.Jun 29, 2008 · N701DW · Substantial damageNTSB LAX08LA200Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Santa Maria, CAThe copilot's misjudged clearance from an object during a hovering turn for landing. Contributing to the accident were the inadequately marked heliport surface and the close proximity of an obstruction near the landing area.Jun 27, 2008 · N343AA · Substantial damageNTSB LAX08CA216Accident · No injuriesData collectionFinal reportCessna 172M · Skykomish, WAThe pilot's inadequate in-flight planning/decision and failure to execute a go-around when the airplane floated during the flare. Contributing to the accident was the short and wet turf runway surface, which reduced braking action.Jun 27, 2008 · N94HJ · Substantial damageNTSB LAX08CA173Accident · Minor injuriesData collectionFinal reportBeech A36 · Ryegate, MTThe pilot's failure to abort the takeoff when the ground roll acceleration profile was determined to be insufficient for takeoff. Contributing to the accident was the shifting wind conditions.Jun 26, 2008 · N824C · Substantial damageNTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.Jun 25, 2008 · N3504X · Substantial damageNTSB LAX08CA245Accident · No injuriesData collectionFinal reportCessna 180 · Atlanta, IDThe pilot's misjudged speed and distance during the intentional touchdown in the last half of the runway, which resulted in a landing overrun. Contributing to the accident was the muddy runway condition.Jun 15, 2008 · N2294C · Substantial damageNTSB LAX08CA176Accident · No injuriesData collectionFinal reportClarke Colin Glastar · Wenatchee, WAThe pilot's failure to initiate a timely go-around after the first bounce.Jun 10, 2008 · N1935C · Substantial damageNTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.Jun 9, 2008 · N9328H · Substantial damageNTSB CHI08CA159Accident · No injuriesData collectionFinal reportCessna 172P · Athens, OHThe student pilot's failure to maintain directional control during landing. A factor contributing to the accident was a nose wheel vibration.Jun 9, 2008 · N230U · Substantial damageNTSB LAX08CA172Accident · No injuriesData collectionFinal reportCessna T337G · GreatBarrington, MAThe pilot's misjudgment of distance and altitude, and failure to attain the proper touchdown point. The pilot's delayed remedial action was also causal.Jun 8, 2008 · N337JJ · Substantial damageNTSB CHI08CA155Accident · No injuriesData collectionFinal reportCessna 180 · Eveleth, MNThe pilot elected to land on a grass airstrip that was unsuitable for landing due to the wet, soft runway conditions. The wet, soft runway were factors.Jun 7, 2008 · N4701U · Substantial damageNTSB DEN08CA099Accident · No injuriesData collectionFinal reportPiper Seneca · Plaquemine, LAThe certified flight instructor's poor decision to simulate a loss of engine on takeoff with a wet runway and the pilot's failure to maintain directional control. Contributing to the accident was the dew covered runway surface and the ditch.May 31, 2008 · N864CA · Substantial damageNTSB LAX08CA156Accident · No injuriesData collectionFinal reportCessna 172P · Troutdale, ORThe student pilot's failure to maintain directional control, which resulted in collision with a runway light.May 24, 2008 · N62348 · Substantial damageNTSB NYC08CA188Accident · No injuriesData collectionFinal reportPilatus PC-12 · Burnsville, NCThe pilot's failure to maintain directional control while landing. Contributing to the accident was the gusty wind conditions.May 22, 2008 · N522DJ · Substantial damageNTSB LAX08CA170Accident · No injuriesData collectionFinal reportScottish Bulldog 120 · Truckee, CAThe pilot's inadequate compensation for the gusting crosswind and misjudged landing flare.May 19, 2008 · N416JA · Substantial damageNTSB LAX08CA147Accident · No injuriesData collectionFinal reportBeech B-23 · Bagdad, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain runway alignment. Contributing factors were the gusty crosswind weather conditions and the rocky terrain adjacent to the runway.May 17, 2008 · N4026T · Substantial damageNTSB ANC08CA069Accident · No injuriesData collectionFinal reportCessna 421 · Caldwell, NJThe pilot's failure to maintain directional control while landing. Factors in the accident were a hydroplaning condition, and a wet runway.May 17, 2008 · N777FF · Substantial damageNTSB DFW08CA145Accident · No injuriesData collectionFinal reportWeatherly 201B · Nickerson, KSThe pilot's failure to maintain directional control during the takeoff roll.May 15, 2008 · N1264W · DestroyedNTSB MIA08CA100Accident · No injuriesData collectionFinal reportCessna 172A · Jamestown, PAThe pilot's failure to maintain control after takeoff resulting in contact with the ground. Contributing to the accident was the pilot's inadequate preflight planning resulting in a takeoff from a short, wet, soft, runway.May 13, 2008 · N9822T · Substantial damageNTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.May 10, 2008 · N8103E · Substantial damageNTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.May 9, 2008 · N9030E · Substantial damageNTSB LAX08CA125Accident · Minor injuriesData collectionFinal reportGrumman AA-5A · Atlanta, IDThe pilot's failure to attain and maintain an adequate airspeed during the takeoff to clear trees during the initial climb. Contributing factors were the soft and rough nature of the short runway surface.May 4, 2008 · N9720U · Substantial damageNTSB SEA08CA126Accident · No injuriesData collectionFinal reportCessna 172M · Dixie, IDThe pilot's failure to maintain adequate clearance from the vegetation during takeoff.May 3, 2008 · N20406 · Substantial damageNTSB CHI08CA117Accident · No injuriesData collectionFinal reportCessna 182D · Madison, INThe inadequate preflight inspection of the landing gear tires by the pilot, which did not identify a worn tire and resulted in a flat tire during landing touchdown. An additional cause was the directional control not possible during the landing rollout, and…Apr 27, 2008 · N9111X · Substantial damageNTSB LAX08CA123Accident · Minor injuriesData collectionFinal reportErvin SHA Glasair · Elk Creek, CAThe pilot's misjudged landing flare, inadequate bounced landing recovery technique, and failure to attain and maintain an adquate airspeed during an aborted landing. Contributing to the accident was the short runway.Apr 26, 2008 · N41SS · Substantial damageNTSB LAX08CA096Accident · No injuriesData collectionFinal reportCessna T210N · Coaldale, NVThe pilot's failure to maintain directional control after encountering an unknown object on the dirt runway.Apr 25, 2008 · N6182N · Substantial damageNTSB SEA08CA111Accident · Minor injuriesData collectionFinal reportAviat A-1C-200 · Bluff, UTThe pilot's inadequate short-field landing procedure and excessive airspeed that resulted in a landing overrun. Contributing to the accident were gusting unfavorable winds, the short runway, and rocks off the departure end of the strip.Apr 24, 2008 · N134DD · Substantial damageNTSB ANC08CA056Accident · No injuriesData collectionFinal reportAeronca 15AC · Anchorage, AKThe pilot's excessive use of brakes during the landing roll. A factor was an excessive taxispeed.Apr 24, 2008 · N1452H · Substantial damageNTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.Apr 23, 2008 · N1682G · Substantial damageNTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.Apr 18, 2008 · N2710P · Substantial damageNTSB LAX08CA114Accident · No injuriesData collectionFinal reportMurphy Murphy Rebel · Grass Valley, CAThe pilot's failure to maintain directional control.Apr 17, 2008 · N3VK · Substantial damageNTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…Apr 17, 2008 · N6260J · DestroyedNTSB LAX08CA102Accident · No injuriesData collectionFinal reportCessna 172S · Gualala, CAThe pilot's decision not to use all of the available runway, his premature rotation and failure to obtain and maintain an adequate airspeed to continue the takeoff that resulted in a stall/mush, an aborted takeoff, a runway overrun, and a collision with…Apr 13, 2008 · N21705 · Substantial damageNTSB NYC08CA166Accident · No injuriesData collectionFinal reportWim J Huisman Velocity 173 Fixed · Ocala, FLThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the wind gusts.Apr 12, 2008 · N127DH · Substantial damageNTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.Apr 12, 2008 · N9277E · Substantial damageNTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.Apr 12, 2008 · N36V · Substantial damageNTSB NYC08CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's loss of directional control on landing. Contributing to the accident was the crosswind and wind gusts.Apr 7, 2008 · N9233X · Substantial damageNTSB DFW08LA089Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Abbeville, LAThe failure of both pilots to see and avoid the other approaching airplane. A contributing factor was the close proximity between the two private airstrips.Mar 28, 2008 · N9097P · 2 aircraft · Substantial damageNTSB NYC08IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS355F1 · New York, NYThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from the other helicopter due to his focus on the engine instruments during the initial departure. Contributing to the accident was insufficient helipad spacing.Mar 22, 2008 · N406LH · Minor damageNTSB LAX08CA082Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilot's inadequate compensation for the wind conditions, failure to attain and maintain an adequate airspeed that resulted in a stall mush, and, the subsequent failure to maintain terrain and obstacle clearance during the takeoff initial climb.…Mar 22, 2008 · N63D · Substantial damageNTSB LAX08LA078Accident · 1 fatalLimited investigationFinal reportJenkins RV-7A · Winslow, AZThe pilot's failure to maintain an adequate airspeed that resulted in a stall/spin.Mar 18, 2008 · N742MJ · Substantial damageNTSB DEN08LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Glenwood Spring, COThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was the strong left quartering tailwind and gust.Mar 18, 2008 · N67WW · Substantial damageNTSB DEN08LA066Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Las Vegas, NMAn inadvertent settling with power, and the instructor's failure to maintain control of the helicopter, resulting in a hard landing. Contributing to the accident was the downdraft.Mar 18, 2008 · N3055N · Substantial damage