NTSB investigations, 2008, CA

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

Cases per year

20082026
NTSB investigations, 2008, 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\") = 2008
    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 WPR09CA064Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Dinuba, CAThe failure of maintenance personnel to properly install the engine's Py line correctly, which resulted in the total loss of engine power and subsequent force landing. Contributing to the accident was the lack of suitable terrain.Dec 16, 2008 · N1035F · Substantial damageNTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.Sep 2, 2008 · N750PJ · Substantial damageNTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.Aug 20, 2008 · N818CT · Substantial damageNTSB SEA08CA165Accident · No injuriesData collectionFinal reportAntares - Balaban MA33 · Byron, CAThe pilot's failure to maintain an adequate airspeed, which resulted in a stall/mush.Jul 22, 2008 · N92287 · Substantial damageNTSB LAX08LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Butte City, CAA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot's failure to verify the fuel quantity prior to flight.May 6, 2008 · N703Y · Substantial damageNTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.Feb 29, 2008 · N2571D · Substantial damageNTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.Jan 7, 2008 · N30WH · Substantial damage