NTSB investigations, 2008, CA

8 cases where the sequence of events included Landing gear collapse.

Cases per year

20082026
NTSB investigations, 2008, CA per year, 2008–2026: 135 cases
20088
200910
201011
20115
20125
20137
20147
20158
201610
201714
201812
20197
20205
20212
20224
20235
20245
20254
20266

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\" = '094' 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 SEA08CA202Accident · No injuriesData collectionFinal reportMooney M20K · Trinity Center, CAThe complete loss of engine power due to fuel exhaustion as a result of a leak in the fuel system. Contributing to the accident was the rough terrain the airplane encountered during the forced landing.Sep 12, 2008 · N1157K · Substantial damageNTSB LAX08CA202Accident · No injuriesData collectionFinal reportBeech F33/G · Groveland, CAThe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain proper alignment at touchdown resulting in a side load on the landing gear, which caused them to collapse.Jun 28, 2008 · N331HP · Substantial damageNTSB LAX08CA165Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe flight instructor's inadequate compensation for the wind conditions, and his inadequate supervision of the student pilot. Factors contributing to the accident were a sudden wind shift and wind gusts.Jun 6, 2008 · N73403 · Substantial damageNTSB LAX08CA162Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Shafter, CAThe pilot's misjudged landing flare that resulted in a hard landing.Jun 1, 2008 · N28290 · Substantial damageNTSB LAX08CA170Accident · No injuriesData collectionFinal reportScottish Bulldog 120 · Truckee, CAThe pilot's inadequate compensation for the gusting crosswind and misjudged landing flare.May 19, 2008 · N416JA · Substantial damageNTSB LAX08LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Maria, CAThe pilot's impairment from alcohol and his improper flare, which resulted in a bounced landing. Contributing to the accident was the FAA's failure to obtain additional information about the pilot's alcohol use history to verify that he met the requirements…May 15, 2008 · N4660K · Substantial damageNTSB LAX08CA157Accident · No injuriesData collectionFinal reportPiper PA-34 · Blythe, CAThe pilot's failure to maintain directional control.May 10, 2008 · N103JH · Substantial damageNTSB SEA08LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Placerville, CAThe collapse of the right main landing gear during landing for undetermined reasons.Jan 12, 2008 · N7988P · Substantial damage