NTSB investigations, 2013

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

Cases per year

20082026
NTSB investigations, 2013 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\") = 2013
    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 WPR13LA419Accident · No injuriesLimited investigationFinal reportPiper PA60 602P · Sandpoint, IDThe pilot's failure to fly the approach at the appropriate landing speed and attain the correct touchdown point, which resulted in a runway overrun.Sep 23, 2013 · N35FD · Substantial damageNTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.Sep 21, 2013 · N99KL · Substantial damageNTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 25, 2013 · N4888Z · Substantial damageNTSB WPR13CA362Accident · No injuriesData collectionFinal reportBellanca 7GCBC · West Yellowstone, MTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with an approach slope indicator system component.Aug 1, 2013 · N926BW · Substantial damageNTSB CEN13CA303Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TXThe pilot's delay to not perform a go-around when he lost sight of the runway while on final approach to land at night. Contributing to the accident was the obscuration (tall grass) of the runway edge lights.Apr 14, 2013 · N6784F · Substantial damageNTSB WPR13LA111Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Boise, IDThe pilot's failure to maintain a proper glidepath and stabilized approach, which resulted in the airplane touching down short of the runway.Feb 3, 2013 · N8465L · Substantial damage