NTSB investigations, 2015

12 cases where NTSB found Sign/marker.

Cases per year

20082026
NTSB investigations, 2015 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\") = 2015
    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 WPR16LA030Accident · Serious injuriesLimited investigationFinal reportCessna T210N · La Verne, CAThe total loss of engine power for reasons that could not be determined based on the available information.Nov 19, 2015 · N91HC · Substantial damageNTSB GAA15CA249Accident · No injuriesData collectionFinal reportStinson L 5E · Tucson, AZThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and a collision with an object.Aug 20, 2015 · N944LB · Substantial damageNTSB ERA15LA263Accident · Minor injuriesLimited investigationFinal reportCessna 210 5A(205A) · Stafford Twp, NJThe total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic's failure to properly torque the engine cylinder through bolts.Jul 12, 2015 · N315EC · Substantial damageNTSB GAA15CA144Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Williston, NDThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with runway marking signs.Jun 28, 2015 · N8723 · Substantial damageNTSB GAA15CA120Accident · No injuriesData collectionFinal reportBeech RC 45J · Everett, WAThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with a sign.Jun 11, 2015 · N585PB · Substantial damageNTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.Jun 9, 2015 · N6919W · Substantial damageNTSB ERA15LA214Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Inverness, FLA disconnection of the tailwheel steering mechanism during landing, which resulted in the pilot’s loss of directional control.May 12, 2015 · N43715 · Substantial damageNTSB WPR15LA157Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Redlands, CAThe partial loss of engine power during takeoff due to oil starvation.May 9, 2015 · N4124R · Substantial damageNTSB GAA15CA060Accident · No injuriesData collectionFinal reportWatson David E Skybolt · Carson City, NVThe pilot's failure to maintain directional control of the airplane during takeoff, resulting in substantial damage to the airplane.May 4, 2015 · N88FX · Substantial damageNTSB GAA15CA042Accident · Minor injuriesData collectionFinal reportCessna 140 · Mize, MSThe pilot's failure to maintain clearance from obstacles during an off airport precautionary landing roll.Apr 18, 2015 · N76452 · Substantial damageNTSB GAA15CA017Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Greensboro, NCThe pilot's failure to maintain directional/pitch control during final approach, resulting in a collision with terrain.Mar 18, 2015 · N43MT · Substantial damageNTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.Jan 27, 2015 · N805ER · Substantial damage