NTSB investigations, 2018

16 cases where NTSB found Runway/taxi/approach light.

Cases per year

20082026
NTSB investigations, 2018 per year, 2008–2026: 106 cases
200811
20094
20101
20111
20123
20136
20147
20154
20167
201712
201816
201913
202011
20213
20225
20241
20251

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\") = 2018
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022012'))
  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 GAA19CA052Accident · No injuriesData collectionFinal reportPiper PA28 · Merced, CAThe pilot's improper glidepath during a landing at night, which resulted in a collision with approach lights.Nov 4, 2018 · N2956B · Substantial damageNTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.Oct 5, 2018 · N6674Y · Substantial damageNTSB GAA19CA016Accident · No injuriesData collectionFinal reportPiper PA24 · Winder, GAThe pilot’s failure to maintain an adequate approach path at night after an electrical failure, which resulted in the airplane striking runway lights.Oct 4, 2018 · N8220P · Substantial damageNTSB ERA18TA255Accident · Serious injuriesFinal reportCalvin Nate H Velocity STD RG E · Kingsport, TNThe pilot's failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a partial loss of power and an aerodynamic stall.Sep 20, 2018 · N67WR · Substantial damageNTSB GAA18CA579Accident · Minor injuriesData collectionFinal reportPiper PA28 · Porterville, CAThe pilot's failure to maintain directional control during the landing roll.Aug 31, 2018 · N8172N · Substantial damageNTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.Aug 25, 2018 · N7635F · Substantial damageNTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.Jul 24, 2018 · N20342 · Substantial damageNTSB GAA18CA406Accident · No injuriesData collectionFinal reportBeech 76 · Fort Lauderdale, FLThe pilot receiving instruction's failure to maintain a proper approach path and her delayed go-around during a simulated emergency landing, which resulted in landing short of the runway. Contributing to the accident was the flight instructor's failure to…Jul 9, 2018 · N66340 · Substantial damageNTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.Jun 15, 2018 · N8273C · Substantial damageNTSB WPR18LA166Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Plant City, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the…Jun 11, 2018 · N13RF · Substantial damageNTSB CEN18LA220Accident · No injuriesLimited investigationFinal reportBeech A23 · Sedalia, MOThe pilot’s loss of directional control during the landing rollout due to the unexpected wind shift, which resulted in a runway excursion.Jun 7, 2018 · N8775M · Substantial damageNTSB GAA18CA236Accident · No injuriesData collectionFinal reportL-Bird CCX-2000 · Hood River, ORThe pilot’s decision to take off in gusting wind conditions, which resulted in a loss of directional control.Apr 27, 2018 · N844FC · Substantial damageNTSB GAA18CA222Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Saratoga Springs, NYThe glider pilot’s failure to maintain pitch during a CG aerotow, which resulted in the loss of control of the tow airplane.Apr 22, 2018 · N7247Z · Substantial damageNTSB GAA18CA218Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Pensacola, FLThe pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.Apr 15, 2018 · N8115Y · Substantial damageNTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Mar 30, 2018 · N24751 · Substantial damageNTSB GAA18CA183Accident · No injuriesData collectionFinal reportGlobe GC 1B · Fullerton, CAThe pilot’s failure to maintain directional control during the takeoff roll resulting impact with PAPI lighting.Mar 27, 2018 · N78244 · Substantial damage