NTSB investigations, 2017, CA

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

Cases per year

20082026
NTSB investigations, 2017, 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\") = 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\" = '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 WPR18LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 150L · Perris, CAThe presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor.Dec 25, 2017 · N6627G · Substantial damageNTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 19, 2017 · N69656 · Substantial damageNTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.Oct 22, 2017 · N83512 · 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 WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.Sep 4, 2017 · N75753 · Substantial damageNTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.Jul 27, 2017 · N5596C · Substantial damageNTSB GAA17CA352Accident · No injuriesData collectionFinal reportPiper PA 18 · Red Bluff, CAThe pilot’s failure to maintain pitch control during the landing roll in gusting wind conditions, which resulted in a nose-over.Jun 18, 2017 · N4420Z · Substantial damageNTSB GAA17CA354Accident · No injuriesData collectionFinal reportPiper PA28 · Big Bear, CAThe pilot’s improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.Jun 4, 2017 · N9238W · Substantial damageNTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.May 24, 2017 · N708PV · Substantial damageNTSB GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.May 15, 2017 · N184ME · Substantial damageNTSB GAA17CA301Accident · No injuriesData collectionFinal reportZwicker Murray R Glastar · Napa, CAThe amphibious float-equipped airplane's encounter with a submerged object during a water landing, which resulted in a nose-over.Apr 30, 2017 · N89SR · Substantial damageNTSB WPR17LA094Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 52 · Porterville, CAA partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined.Apr 29, 2017 · N132MD · Substantial damageNTSB GAA17CA230Accident · No injuriesData collectionFinal reportCessna 180 · Manchester, CAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the total loss of engine power.Apr 12, 2017 · N7945V · Substantial damageNTSB GAA17CA171Accident · Minor injuriesData collectionFinal reportSmith Douglas J. Sonex · Mercey Hot Springs, CAThe sport pilot’s unstabilized approach with a tailwind, which resulted in touchdown short of the runway and a subsequent nose-over.Mar 1, 2017 · N801SX · Substantial damageNTSB GAA17CA168Accident · Minor injuriesData collectionFinal reportMaule MX7 · Live Oak, CAThe pilot’s failure to maintain a stabilized approach and his subsequent incorrect brake application during the landing roll, which resulted in a nose-over.Mar 1, 2017 · N600XX · Substantial damageNTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.Jan 15, 2017 · N1659E · Substantial damage