NTSB investigations, 2015

206 cases where the sequence of events included Off-field or emergency landing.

Cases, newest first

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…Jan 16, 2015 · N232LT · Substantial damageNTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…Jan 9, 2015 · N7ZL · Substantial damageNTSB ERA15LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Norfolk, VAThe engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.Jan 6, 2015 · N2102P · Substantial damageNTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.Jan 6, 2015 · N246JT · Substantial damageNTSB ERA15LA090Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Key West, FLA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.Jan 3, 2015 · N2534X · Substantial damageNTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.Jan 2, 2015 · N81291 · Substantial damage