NTSB investigations, 2010, CA

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.Dec 2, 2010 · N11858 · Substantial damageNTSB WPR11LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Suisun City, CAA total loss of engine power for undetermined reasons.Nov 27, 2010 · N5582T · Substantial damageNTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.Nov 24, 2010 · N459CT · Substantial damageNTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 22, 2010 · N6064N · Substantial damageNTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.Sep 2, 2010 · N522PC · Substantial damageNTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.Aug 14, 2010 · N677DS · Substantial damageNTSB WPR10CA403Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 582S · Petaluma, CAThe pilot’s improper flare, resulting in a hard landing and nose over.Aug 14, 2010 · N468DW · Substantial damageNTSB WPR10FA387Accident · Minor injuriesField investigationFinal reportPZL Mielec M18 · Meridian, CALong-term deterioration of multiple engine fuel vaporizers that led to material failure of multiple turbine blades, which resulted in a complete loss of engine power. Contributing to the accident were the exceedance of specified engine inspection intervals…Aug 6, 2010 · N70461 · Substantial damageNTSB WPR10CA428Accident · No injuriesData collectionFinal reportHolmgreen John B RV8A · Carlsbad, CAThe pilot’s inadequate pretakeoff checks and failure to maintain control during the takeoff roll. Contributing to the accident was the pilot’s diverted attention due to the open canopy.Aug 1, 2010 · N525JH · Substantial damageNTSB WPR10LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Columbia, CAThe pilot's failure to maintain directional control during landing roll.Apr 7, 2010 · N2629D · Substantial damageNTSB WPR10CA176Accident · No injuriesData collectionFinal reportCessna 182Q · Fallbrook, CAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 23, 2010 · N735KL · Substantial damageNTSB WPR10CA152Accident · No injuriesData collectionFinal reportCessna 172P · Camarillo Airport, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during landing.Mar 7, 2010 · N23FR · Substantial damageNTSB WPR10LA125Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Byron, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Feb 23, 2010 · N8494K · Substantial damageNTSB WPR10CA101Accident · Minor injuriesData collectionFinal reportCessna 195B · Palm Springs, CAThe pilot's improper use of brakes during landing.Jan 7, 2010 · N2171C · Substantial damageNTSB WPR10CA098Accident · Minor injuriesData collectionFinal reportCessna 172R · Ramona, CAThe pilot's failure to maintain directional control during a touch-and-go landing.Jan 6, 2010 · N35414 · Substantial damageNTSB WPR10CA095Accident · No injuriesData collectionFinal reportCessna 182P · Fallbrook, CAThe pilot's misjudged altitude and airspeed that resulted in his failure to attain the proper touchdown point.Jan 3, 2010 · N7417N · Substantial damage