NTSB investigations, 2014

10 cases where NTSB found Sign/marker.

Cases per year

20082026
NTSB investigations, 2014 per year, 2008–2026: 214 cases
200825
200911
201015
20112
20126
201310
201410
201512
201621
201720
201824
201919
20209
20219
20223
20237
20245
20253
20263

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\") = 2014
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022015'))
  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 CEN15CA049Accident · No injuriesData collectionFinal reportCessna 210 · Kalamazoo, MIThe pilot's failure to ensure that the landing gear was fully extended in the down and locked position prior to touchdown, which resulted in the left main landing gear collapse, runway excursion, and impact with a runway exit sign.Oct 24, 2014 · N8219M · Substantial damageNTSB ERA15LA030Accident · No injuriesLimited investigationFinal reportNorth American T 6G · Naples, FLThe total loss of engine power during the initial climb due to fuel starvation for reasons that could not be determined because postaccident examinations of the airframe and engine fuel system components revealed no evidence of a mechanical malfunction or…Oct 23, 2014 · N22NA · Substantial damageNTSB CEN14CA291Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Middleton, WIThe pilot's failure to maintain directional control during takeoff.Jun 5, 2014 · N752J · Substantial damageNTSB ERA14CA277Accident · No injuriesData collectionFinal reportCessna 177B · Cartersville, GAThe pilot's failure to maintain directional control during a go-around after landing.Jun 2, 2014 · N30820 · Substantial damageNTSB WPR14CA163Accident · No injuriesData collectionFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain directional control during a takeoff, which resulted in the airplane veering off the runway surface and colliding with a sign.Apr 10, 2014 · N1152Z · Substantial damageNTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.Mar 6, 2014 · N108WA · Substantial damageNTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.Feb 25, 2014 · N156WB · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.Jan 19, 2014 · N1960C · Substantial damageNTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.Jan 12, 2014 · N6888 · Substantial damage