NTSB investigations, 2012

15 cases where NTSB found Runway/land/takeoff/taxi surface, general.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 253 cases
200868
200919
201014
201121
201215
201312
20149
20158
201613
201718
20188
20195
20208
202111
20228
20235
20245
20255
20261

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\") = 2012
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023000'))
  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 WPR13TA081Accident · No injuriesFinal reportBell Helicopter Textron Canada 407 · Renton, WAThe pilot's failure to maintain helicopter control during takeoff from an unstable landing platform. Contributing to the accident was the operator's inadequate chocking procedures for the wheeled landing platform, which included chocking only two of the…Dec 28, 2012 · N407KS · Substantial damageNTSB WPR13CA027Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hanapepe, HIThe pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.Oct 29, 2012 · N216AB · Substantial damageNTSB CEN13CA033Accident · Serious injuriesData collectionFinal reportPorter James Grant Superior CUB · Beechgrove, INThe pilot’s failure to maintain clearance from trees during takeoff from a short field.Oct 27, 2012 · N97RP · Substantial damageNTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.Sep 2, 2012 · N67178 · Substantial damageNTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.Aug 31, 2012 · N1620A · Substantial damageNTSB ANC12CA089Accident · No injuriesData collectionFinal reportMaule M-5-210C · Coldfoot, AKThe pilot's delayed decision to turn around while flying through a narrow mountain pass, which resulted in a forced landing and impact with terrain.Aug 18, 2012 · N319X · Substantial damageNTSB CEN12LA507Accident · No injuriesLimited investigationFinal reportCessna 150M · Cottage Grove, WIThe pilot's decision to land on a runway with significant overgrown vegetation along the edges and his landing, which was left of the centerline.Jul 31, 2012 · N45080 · Substantial damageNTSB WPR12CA319Accident · No injuriesData collectionFinal reportDornier DO 27 B5 · Jackson Hole, WYThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear.Jul 22, 2012 · N780AX · Substantial damageNTSB ANC12CA077Accident · No injuriesData collectionFinal reportBell 206L-3 · Circle, AKThe pilot's selection of unsuitable terrain for landing.Jul 20, 2012 · N363AL · Substantial damageNTSB ANC12CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a loss of control during the landing roll.Jul 6, 2012 · N623JE · Substantial damageNTSB ANC12LA061Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot’s failure to properly judge the airplane’s distance and altitude from the landing location during the final approach, which resulted in an undershoot and a nose over.Jun 30, 2012 · N63562 · Substantial damageNTSB ANC12LA056Accident · Serious injuriesLimited investigationFinal reportHelio H-295-1400 · Deadhorse, AKThe pilot's failure to extend the airplane’s wing flaps before takeoff and her selection of an unsuitable takeoff area, which resulted in a collision with a concrete loading ramp during the aborted takeoff.Jun 20, 2012 · N295SC · Substantial damageNTSB WPR12CA270Accident · No injuriesData collectionFinal reportFisher Harold R 320 · Adelanto, CAThe pilot's failure to maintain clearance from a fence during takeoff initial climb. Contributing to the accident was the pilot's decision to not use all of the runway distance available for takeoff and the high density altitude.Jun 17, 2012 · N686KB · Substantial damageNTSB ANC12CA049Accident · No injuriesData collectionFinal reportCessna U206G · Homer, AKThe pilot's selection of unsuitable terrain for landing.Jun 7, 2012 · N9049G · Substantial damageNTSB ERA12LA343Accident · No injuriesLimited investigationFinal reportCessna 195A · Tipton, PAA fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.May 18, 2012 · N9859A · Substantial damage