NTSB investigations, 2009, CA

19 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2009, CA per year, 2008–2026: 180 cases
200821
200919
201011
201115
20129
20139
20146
201510
201611
201718
20189
20197
20206
20217
20226
20234
20244
20252
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\") = 2009
    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\" = '092' 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 WPR10CA058Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-250 · Napa, CAThe pilot's encounter with variable winds which resulted in a hard landing and passenger injury.Nov 11, 2009 · N4062M · No damageNTSB WPR10CA054Accident · No injuriesData collectionFinal reportCirrus SR20 · Santa Barbara, CAThe pilot's improper flare, which resulted in a hard landing and porpoise pilot induced oscillation.Nov 6, 2009 · N702TM · Substantial damageNTSB WPR10CA037Accident · No injuriesData collectionFinal reportSocata TB200 · Edwards, CAThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the sunglare.Oct 24, 2009 · N3052N · Substantial damageNTSB WPR10FA029Accident · No injuriesField investigationFinal reportAgusta A119 · Blythe, CAThe loss of engine power during cruise flight for undetermined reasons.Oct 23, 2009 · N119AH · Substantial damageNTSB WPR10TA025Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 500N · Los Alamitos, CAThe flight instructor's delayed remedial action during the instructional autorotative landing, which resulted in a failure to maintain an adequate rotor rpm to avoid a hard landing.Oct 16, 2009 · N521HB · Substantial damageNTSB WPR10TA016Accident · Minor injuriesFinal reportMD Helicopter 600 · San Diego, CAThe pilot's failure to maintain adequate main rotor rpm during an autorotation, which resulted in a hard landing.Oct 12, 2009 · N613BP · Substantial damageNTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.Oct 7, 2009 · N2219E · Substantial damageNTSB WPR09CA448Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Irvine, CAThe flight instructor's failure to maintain an adequate airspeed and his delayed recovery action during the practice autorotation, which resulted in a hard landing.Sep 15, 2009 · N796SH · Substantial damageNTSB WPR09LA445Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Chemehuevi Valley, CAThe pilot's improper flare while landing with a tailwind, resulting in a bounced landing.Sep 11, 2009 · N2819R · Substantial damageNTSB WPR09CA441Accident · No injuriesData collectionFinal reportCessna T210H · Avalon, CAThe pilot's failure to maintain airspeed during approach to landing, which resulted in a hard landing.Sep 5, 2009 · N2242R · Substantial damageNTSB WPR09GA397Accident · Serious injuriesFinal reportEurocopter AS 350 B2 · Lancaster, CAThe pilots’ decision to conduct a practice autorotation at low altitude in high density altitude conditions and their failure to attain and maintain an appropriate descent rate. Contributing to the accident was the high density altitude and the pilots’…Aug 13, 2009 · N217LA · Substantial damageNTSB WPR09CA359Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Truckee, CAThe student pilot's failure to maintain adequate airspeed to avoid a stall during final approach to land. Contributing to the accident was the pilot’s lack of experience.Jul 19, 2009 · N65825 · Substantial damageNTSB WPR09LA302Accident · No injuriesLimited investigationFinal reportMooney M20TN · San Jose, CAThe pilot's improper landing flare in gusting wind conditions resulting in a collision with an airport sign.Jun 20, 2009 · N411JL · Substantial damageNTSB WPR09CA279Accident · No injuriesData collectionFinal reportCessna 182T · Shafter, CAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.Jun 8, 2009 · N61907 · Substantial damageNTSB WPR09CA206Accident · No injuriesData collectionFinal reportCessna 172M · Corona, CAThe pilot's improper landing flare.Apr 21, 2009 · N9504H · Substantial damageNTSB WPR09CA209Accident · No injuriesData collectionFinal reportCessna 172P · Livermore, CAThe student pilot’s improper recovery from a bounced landing.Apr 20, 2009 · N64204 · Substantial damageNTSB WPR09CA129Accident · No injuriesData collectionFinal reportCessna T210 · Twentynine Palms, CAThe pilot's inadequate compensation for the gusting wind conditions.Feb 24, 2009 · N210NS · Substantial damageNTSB WPR09GA119Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 600 · San Clemente, CAFailure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.Feb 20, 2009 · N608BP · Substantial damageNTSB WPR09CA118Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Encinitas, CAA partial loss of engine power for an undetermined reason. Contributing to the accident was the soft terrain.Feb 18, 2009 · N588LE · Substantial damage