NTSB investigations, 2012

10 cases where NTSB found Total experience.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 126 cases
200814
200913
20106
20116
201210
201313
20147
20159
20165
20175
20187
201910
20204
20213
20227
20233
20244

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\", '02031015'))
  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 ERA13LA057Accident · 2 fatalLimited investigationFinal reportHughes 369D · Corning, NYThe pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.Nov 15, 2012 · N369AW · Substantial damageNTSB ERA13CA040Accident · No injuriesData collectionFinal reportAeronca 7CCM · Hampton, NHThe student pilot's improper landing flare and touchdown, which resulted in a hard landing.Oct 24, 2012 · N4567E · Substantial damageNTSB ERA12LA541Accident · 1 fatalLimited investigationFinal reportJohnston Douglas S Safari · McVeytown, PAThe pilot's lack of proficiency and certification, which resulted in his failure to enter an autorotation when the engine lost power. Contributing to the accident was the pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent…Sep 1, 2012 · N70415 · Substantial damageNTSB CEN12LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glenwood Springs, COThe pilot's decision to fly into a mountainous area where conditions were such that the airplane was unable to climb above rising terrain. Contributing to the accident was the pilot's insufficient pilot-in-command experience and inadequate training in…Jun 30, 2012 · N917SA · Substantial damageNTSB ERA12FA387Accident · 1 fatalField investigationFinal reportPhillips William L Challenger · Plant City, FLThe non-certificated pilot’s loss of control during approach and landing. Contributing to the accident was the pilot’s lack of both total and recent flight experience.Jun 9, 2012 · N2571T · Substantial damageNTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…Jun 7, 2012 · N950KA · Substantial damageNTSB ERA12CA357Accident · No injuriesData collectionFinal reportHughes TH-55 · Pittsfield, PAThe student pilot's failure to maintain helicopter control during an encounter with loss of tail rotor effectiveness.May 19, 2012 · N74914 · Substantial damageNTSB CEN12CA277Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe student pilot's misjudgment of the landing flare, which resulted in a hard/bounced landing and subsequent impact with the runway.May 1, 2012 · N94500 · Substantial damageNTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…Mar 18, 2012 · N987KB · Substantial damageNTSB WPR12LA126Accident · No injuriesLimited investigationFinal reportQuicksilver MX Sprint II · Willits, CAThe student pilot did not maintain an adequate approach/glide path and altitude, which resulted in a runway undershoot and subsequent collision with trees. Contributing to the accident was the student pilot's lack of flight experience.Mar 8, 2012 · N702U · Substantial damage