NTSB investigations, CA

83 cases where the sequence of events included Low altitude operation/event.

Cases, newest first

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 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\" = '220' 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 WPR11LA179Accident · Serious injuriesLimited investigationFinal reportEagle DW1 · Newman, CAThe pilot’s inadequate visual lookout and failure to maintain clearance from a vehicle during a low-altitude operation.Apr 1, 2011 · N8812A · Substantial damageNTSB WPR11LA122Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas Helicopters 369E (MD500E) · Elverta, CAThe pilot did not maintain rotor blade clearance from an installation rope while maneuvering to install power lines.Feb 4, 2011 · N416WC · Substantial damageNTSB WPR11FA117Accident · Serious injuriesField investigationFinal reportCessna 172 · Glendora, CAThe flight crew's failure to maintain adequate terrain clearance while maneuvering in downdraft conditions over mountains.Jan 31, 2011 · N6922A · Substantial damageNTSB WPR11LA094Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Oakley, CAAn in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…Jan 10, 2011 · N4977X · Substantial damageNTSB WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.Oct 23, 2010 · N2XZ · Substantial damageNTSB WPR11LA016Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, CAThe pilot's failure to maintain clearance from a transmission line during flight.Oct 14, 2010 · N2763M · Substantial damageNTSB WPR11CA011Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain an adequate drift control and skid clearance from the ground and the CFI's inadequate supervision while hovering, resulting in dynamic rollover.Oct 12, 2010 · N853DS · Substantial damageNTSB WPR10CA466Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Mecca, CAThe pilot's failure to maintain clearance from an obstacle while maneuvering.Sep 21, 2010 · N6053H · Substantial damageNTSB WPR10FA399Accident · 2 fatalField investigationFinal reportPiper PA28R · Emigrant Gap, CAThe pilots’ failure to maintain sufficient altitude to clear terrain while maneuvering. Contributing to the accident was the flight instructor’s delayed remedial action.Aug 13, 2010 · N3463Q · Substantial damageNTSB WPR10CA289Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Courtland, CAThe pilot's failure to maintain clearance from terrain during low-altitude maneuvers.Jun 13, 2010 · N6726Q · Substantial damageNTSB WPR10FA162Accident · 2 fatalField investigationFinal reportNorth American AT6 · Bakersfield, CAThe pilots did not maintain clearance from terrain for undetermined reasons.Mar 17, 2010 · N75AG · Substantial damageNTSB WPR10FA131Accident · 2 fatalField investigationFinal reportYakovlev YAK 52 · Redlands, CAThe pilot's failure to maintain aircraft control and altitude sufficient to recover from a low-level aerobatic maneuver.Feb 8, 2010 · N52VY · Substantial damageNTSB WPR09CA339Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Marysville, CAThe pilot’s failure to maintain adequate clearance from the power line wires.Jul 13, 2009 · N244HP · Substantial damageNTSB WPR09FA334Accident · 2 fatalField investigationFinal reportCessna 182P · Mammoth Lakes, CAThe pilot's improper in-flight planning/decision to attempt to fly at a low altitude in a confined area of mountainous terrain in a high density altitude weather condition, and his failure to maintain clearance from the trees.Jul 8, 2009 · N7314S · Substantial damageNTSB WPR09LA325Accident · 2 fatalLimited investigationFinal reportAero Vodochody L-29 · Tehachapi, CAThe pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.Jul 4, 2009 · N97869 · Substantial damageNTSB WPR09LA226Accident · No injuriesLimited investigationFinal reportMD Helicopter 369FF · Santa Clarita, CAThe pilot's failure to maintain clearance from the water while maneuvering at low altitude as a result of the helicopter's grappling hook temporarily becoming ensnared with an underwater obstruction.May 1, 2009 · N67FF · Substantial damageNTSB WPR09CA220Accident · No injuriesData collectionFinal reportBell OH-58A · Arvin, CAThe pilot’s failure to maintain clearance from wires during aerial application maneuvers.Apr 30, 2009 · N175SJ · Substantial damageNTSB WPR09LA203Accident · 1 fatalLimited investigationFinal reportExtra EA-300 · Santa Barbara, CAThe pilot's failure to maintain clearance with terrain for undetermined reasons while performing aerobatics.Apr 20, 2009 · N101PK · Substantial damageNTSB WPR09CA163Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chowchilla, CAThe pilot's failure to maintain clearance from the power lines.Mar 24, 2009 · N139RJ · Substantial damageNTSB WPR09LA124Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Salinas, CAThe pilot's failure to maintain clearance from a wire while intentionally maneuvering at a low altitude.Feb 22, 2009 · N2835G · Substantial damageNTSB WPR09CA088Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S R582 · Ventura, CAThe pilot's failure to maintain clearance from the water.Jan 17, 2009 · N6976C · DestroyedNTSB WPR09FA061Accident · 2 fatalField investigationFinal reportBeech V35 · Warner Springs, CAThe failure of the pilot to maintain clearance from terrain during a low altitude maneuver.Dec 20, 2008 · N1587L · Substantial damageNTSB WPR09CA030Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Friant, CAThe student pilot's failure to execute a go-around in timely manner, which resulted in a collision with terrain. Also causal was the instructor's inadequate supervision of the flight and delayed remedial actions.Oct 31, 2008 · N2346G · Substantial damageNTSB WPR09FA005Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian SKY Arrow 600 · Malibu, CAThe pilot's failure to maintain aircraft control during a low-altitude maneuver. Contributing to the accident was the pilot's decision to perform a maneuver at a low altitude that was insufficient to allow him to recover from the loss of control. Contributing…Oct 8, 2008 · N454SA · Substantial damageNTSB LAX08LA266Accident · 1 fatalLimited investigationFinal reportBowman Titan Tornado II · Needles, CAThe pilot's failure to maintain clearance from a vehicle during a low-altitude flight over a highway.Aug 12, 2008 · N3156B · Substantial damageNTSB LAX08CA223Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164B · Patterson, CAThe pilot's failure to maintain clearance from obstacles while maneuvering.Jul 10, 2008 · N6792Q · Substantial damageNTSB SEA08LA128Accident · Serious injuriesLimited investigationFinal reportMoravan Zlin 50LX · Modesto, CAThe pilot failed to maintain clearance from terrain during a low-altitude maneuver at an airshow. Contributing to the accident was the task overload in the increased frequency congestion.May 10, 2008 · N6660K · Substantial damageNTSB LAX08CA085Accident · No injuriesData collectionFinal reportAyres S2R-600 · Blythe, CAThe pilot's failure to maintain terrain clearance. Contributing factors were the dusk light condition and the pressure the pilot felt to accomplish the flight.Mar 25, 2008 · N5674X · Substantial damageNTSB SEA08CA091Accident · No injuriesData collectionFinal reportBell 206B · Oxnard, CAThe pilot's failure to maintain clearance with terrain during an aerial application.Mar 11, 2008 · N7028J · Substantial damageNTSB SEA08CA081Accident · Minor injuriesData collectionFinal reportSteven Hardie AIR CAM · Duncan Mills, CAThe pilot's failure to maintain clearance with power lines while maneuvering at a low altitude. Contributing factors included the pilot's decision to fly at low altitude and the sun glare condition.Feb 16, 2008 · N30581 · Substantial damageNTSB SEA08LA070Accident · 1 fatalLimited investigationFinal reportKidd Chris Harmon ROC · Maricopa, CAThe pilot's failure to maintain an adequate terrain clearance altitude while maneuvering in mountainous, hilly terrain. Contributing to the accident were hilly terrain, a low ceiling and gusty winds.Feb 2, 2008 · N96KR · DestroyedNTSB LAX08CA054Accident · No injuriesData collectionFinal reportBell OH-58A · Brawley, CAThe pilot's failure to maintain clearance from obstacles. A factor in the accident was the dark night conditions.Jan 30, 2008 · N902SF · Substantial damageNTSB SEA08LA058Accident · 1 fatalLimited investigationFinal reportCorsario MK-5 · Perris, CAThe pilot's failure to maintain clearance from terrain while maneuvering.Jan 10, 2008 · N9639H · Substantial damage