NTSB investigations, CA

304 cases where the sequence of events included Off-field or emergency landing.

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\" = '440' 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 WPR11LA220Accident · No injuriesLimited investigationFinal reportMD Helicopter 369D · Columbia, CAThe loss of power transmission to the main rotor for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation of the helicopter.May 13, 2011 · N124AL · Substantial damageNTSB WPR11LA199Accident · Minor injuriesLimited investigationFinal reportZenith CH-750 · Winchester, CAA total loss of engine power during descent for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Apr 14, 2011 · N632DR · Substantial damageNTSB WPR11FA192Accident · Serious injuriesField investigationFinal reportBeech 35-B33 · Camarillo, CAThe loss of engine power during the landing approach for undetermined reasons.Apr 9, 2011 · N460SR · Substantial damageNTSB WPR11LA187Accident · No injuriesLimited investigationFinal reportZenith 701 · El Centro, CAA partial loss of engine power during the initial climb after takeoff due to oil starvation because of the failure of the No. 2 oil pump drive coupling.Apr 6, 2011 · N128CF · Substantial damageNTSB 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 WPR11LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Agoura Hills, CAThe loss of engine power during cruise flight for undetermined reasons.Mar 11, 2011 · N75224 · Substantial damageNTSB WPR11LA150Accident · No injuriesLimited investigationFinal reportCessna 140A · Newark, CAA loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.Feb 26, 2011 · N5351C · Substantial damageNTSB WPR11LA131Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Novato, CAThe pilot's use of a non-vented fuel cap, which resulted in a total loss of engine power due to fuel starvation.Feb 10, 2011 · N2659E · Substantial damageNTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.Feb 5, 2011 · N6725K · Substantial damageNTSB WPR11FA120Accident · 1 fatalField investigationFinal reportAeronca O-58C · San Luis Obispo, CAThe pilot’s delay in using carburetor heat, which resulted in a loss of engine power due to an encounter with carburetor icing conditions.Feb 3, 2011 · N47503 · Substantial damageNTSB 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 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 WPR11LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Dorrington, CAThe pilot’s failure to use carburetor heat while cruising in carburetor icing conditions, which resulted in a loss of engine power.Oct 23, 2010 · N228KK · 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 WPR10LA465Accident · No injuriesLimited investigationFinal reportMooney M20C · Visalia, CAA partial loss of engine power during takeoff, which resulted from the failure of the spark plug retention mechanism.Sep 21, 2010 · N6090Q · Substantial damageNTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.Sep 16, 2010 · N2153S · Substantial damageNTSB WPR10FA423Accident · Minor injuriesField investigationFinal reportCessna 182 · Ojai, CAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Aug 24, 2010 · N3850D · Substantial damageNTSB WPR10LA420Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · San Diego, CAThe pilot's failure to utilize carburetor heat during initial climb, which resulted in a loss of engine power due to carburetor icing.Aug 23, 2010 · N7186Z · Substantial damageNTSB WPR10LA396Accident · No injuriesLimited investigationFinal reportGrumman G164 · Tracy, CAA total loss of engine power while maneuvering due to an internal catastrophic failure to the master rod and piston connecting rod links.Aug 11, 2010 · N6781K · 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 WPR10CA389Accident · No injuriesData collectionFinal reportLet L 33 Solo · Adelanto, CAThe pilot’s inability to make it to the airport as a result of his inadequate planning for the gusting headwinds.Aug 6, 2010 · N315BA · Substantial damageNTSB WPR10FA385Accident · Minor injuriesField investigationFinal reportPiper PA-24-260C · Ridgecrest, CAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management during cruise flight.Aug 5, 2010 · N9365P · Substantial damageNTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.Aug 2, 2010 · N444YP · Substantial damageNTSB WPR10LA345Accident · No injuriesLimited investigationFinal reportCessna 177 · Chino, CAThe pilot’s inadequate fuel planning which resulted in a loss of engine power during cruise flight due to fuel exhaustion.Jul 11, 2010 · N3295T · Substantial damageNTSB WPR10CA311Accident · No injuriesData collectionFinal reportCessna 172F · Rancho Murieta, CAA total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jul 8, 2010 · N8793U · Substantial damageNTSB WPR10LA316Accident · No injuriesLimited investigationFinal reportMcGlashan T-51 Mustang · Columbia, CAA loss of engine power during approach due to thermal damage to the engine's electronic ignition module. Contributing to the accident was the builder’s placement of the ignition module near the engine’s exhaust.Jun 27, 2010 · N751RM · Substantial damageNTSB WPR10LA284Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Ontario, CAA loss of engine power due to the in-flight separation of the 1-3-5 cylinder induction tube elbow, which was caused by the improper installation of the induction tube elbow by maintenance personnel.Jun 10, 2010 · N121HJ · Substantial damageNTSB WPR10LA247Accident · No injuriesLimited investigationFinal reportAyres S2R · Glenn, CALoss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.May 18, 2010 · N29254 · Substantial damageNTSB WPR10LA214Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Madera, CAA loss of engine power for undetermined reasons.Apr 23, 2010 · N4450 · Substantial damageNTSB WPR10LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182 · El Cajon, CAThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Apr 17, 2010 · N5318B · Substantial damageNTSB WPR10CA181Accident · No injuriesData collectionFinal reportMorrison Joseph Q2 · Frazier Park, CAA partial loss of engine power likely due to the failure of the oil pump.Mar 26, 2010 · N142BP · 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 WPR10LA138Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Parlier, CAThe pilot inadvertently entered a low-G condition during cruise flight, which resulted in a momentary loss of control of the helicopter and mast bumping.Feb 17, 2010 · N313DA · Substantial damageNTSB WPR10LA119Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · La Quinta, CAA loss of engine power during cruise flight due to water contamination in the fuel.Jan 25, 2010 · N243SC · Substantial damageNTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.Dec 17, 2009 · N8520U · Substantial damageNTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.Dec 8, 2009 · N2539D · Substantial damageNTSB WPR10LA063Accident · 1 fatalLimited investigationFinal reportBudd Lancair Legacy · Watsonville, CAA loss of engine power due to oil starvation and the pilot's failure to maintain airspeed while approaching the landing area resulting in an aerodynamic stall, rapid descent, and collision with terrain.Nov 21, 2009 · N7JX · Substantial damageNTSB WPR10FA056Accident · 1 fatalField investigationFinal reportBeech A36 · San Gabriel, CAFailure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.Nov 15, 2009 · N17803 · Substantial damageNTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.Nov 11, 2009 · N9617Y · 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 WPR10LA014Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Franklin, CAA total loss of engine power due to fuel starvation, as a result of the certified flight instructor's improper fuel system management.Oct 10, 2009 · N649BV · Substantial damageNTSB WPR09LA460Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Valley Center, CAThe failure of the engine’s camshaft due to fatigue of unknown origin.Sep 20, 2009 · N4174P · Substantial damageNTSB WPR09LA452Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Paula, CAA total loss of engine power during takeoff for undetermined reasons.Sep 16, 2009 · N326DW · Substantial damageNTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.Sep 4, 2009 · N2482R · DestroyedNTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsAug 23, 2009 · N8775P · Substantial damageNTSB WPR09LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Firebaugh, CAA total loss of engine power due to fuel exhaustion that was due to the failure of company ground personnel to refuel the airplane. Contributing to the accident was unsuitable terrain for a forced landing.Jul 29, 2009 · N23189 · Substantial damageNTSB WPR09LA373Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Riverdale, CAThe partial loss of engine power due to the failure of the engine's supercharger-blower.Jul 28, 2009 · N8741H · Substantial damageNTSB WPR09LA369Accident · Minor injuriesLimited investigationFinal reportBrown Michael Kitfox IV · Escondido, CAA total loss of power due to an oil exhaustion induced seizure of the engine. The pilot's decision to continue flight to the original destination after becoming aware of the in-flight oil leak instead of landing at an intermediate airport to investigate the…Jul 25, 2009 · N6140S · Substantial damageNTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.Jul 18, 2009 · N9772Y · Substantial damage