NTSB investigations, 2015, CA

9 cases where the sequence of events included Nose over/nose down.

Cases per year

20082026
NTSB investigations, 2015, CA per year, 2008–2026: 179 cases
20087
200917
201016
201112
20128
20138
20146
20159
201617
201716
201812
201914
20207
20214
20222
20236
20248
20253
20267

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\") = 2015
    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\" = '096' 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 GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.Nov 29, 2015 · N99210 · Substantial damageNTSB WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.Oct 24, 2015 · N3124N · Substantial damageNTSB WPR15LA262Accident · No injuriesLimited investigationFinal reportGraves Bryon S Vans RV-7A · Byron, CAImproper overhaul of the right magneto, which eliminated system redundancy, and resulted in a loss of engine power when the left magneto failed during aerobatic flight maneuvers.Sep 21, 2015 · N507RV · Substantial damageNTSB WPR15LA230Accident · No injuriesLimited investigationFinal reportGrumman G164 - B · Princeton, CAThe loss of engine power during an agricultural application flight due to a cylinder failure.Aug 4, 2015 · N48452 · Substantial damageNTSB WPR15CA207Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Carlsbad, CAThe pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.Jul 4, 2015 · N8075P · Substantial damageNTSB GAA15CA113Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Bakersfield, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with terrain.Jun 9, 2015 · N8372 · Substantial damageNTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.Feb 9, 2015 · CFGQQ · Substantial damageNTSB 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 WPR15CA074Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · San Luis Obispo, CAThe accidental application of the brakes by the passenger during landing roll which resulted in the airplane nosing over.Jan 3, 2015 · N171L · Substantial damage