NTSB investigations, 2017, CA

11 cases where the sequence of events included Controlled flight into terr/obj (CFIT).

Cases per year

20082026
NTSB investigations, 2017, CA per year, 2008–2026: 85 cases
20086
20097
20107
20114
20127
20136
20144
20156
20162
201711
20181
20196
20204
20213
20222
20233
20243
20263

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\") = 2017
    AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '120' 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 WPR18LA049Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · El Cajon, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Dec 17, 2017 · N8884H · Substantial damageNTSB WPR18LA007Accident · No injuriesClass 3 · LimitedFinal reportThomas Stephen Glasair Super II RG · Santa Ynez, CAA partial loss of engine power for reasons that were not determined.Oct 5, 2017 · N248ST · Substantial damageNTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.Sep 27, 2017 · N9346G · Substantial damageNTSB WPR17LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 5 · Salinas, CAThe pilot’s inadequate visual lookout, which resulted in an in-flight collision with a wire.Sep 17, 2017 · N3285T · Substantial damageNTSB WPR17FA196Accident · 1 fatalField investigationFinal reportCessna 172N · Bolinas, CAThe non-instrument rated private pilot's improper decision to embark on a flight and continue to fly into forecasted instrument meteorological conditions and mountain obscuration while conducting a visual flight rules flight.Sep 7, 2017 · N737QQ · Substantial damageNTSB WPR17FA179Accident · 1 fatalField investigationFinal reportMichaelian Lancair IV-TP · Rio Linda, CAA loss of engine power for reasons that could not be determined based on available evidence.Aug 3, 2017 · N420M · Substantial damageNTSB WPR17LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Carpinteria, CAThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 10, 2017 · N2171D · Substantial damageNTSB WPR17FA125Accident · 1 fatalField investigationFinal reportBeech 95 C55 · Mountain Ranch, CAThe pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.Jun 9, 2017 · N3717Q · DestroyedNTSB WPR17FA105Accident · 2 fatalField investigationFinal reportSocata TB 20 Trinidad · Sierraville, CAThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.Apr 17, 2017 · N28070 · DestroyedNTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.Feb 12, 2017 · N2179L · Substantial damageNTSB WPR17FA055Accident · 1 fatalField investigationFinal reportMooney M20J · Lake Hughes, CAThe pilot's controlled flight into mountainous terrain while attempting to operate under visual flight rules in instrument meteorological conditions (IMC).Jan 12, 2017 · N6201N · Substantial damage