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 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 WPR09LA337Accident · Minor injuriesLimited investigationFinal reportEngineering & Research 415C · Corona, CAA total loss of engine power during cruise flight for undetermined reasons.Jul 11, 2009 · N87295 · Substantial damageNTSB WPR09LA330Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Tracy, CAThe loss of engine power for undetermined reasons.Jul 3, 2009 · N51459 · Substantial damageNTSB WPR09LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Desert Center, CAA partial loss of engine power due to low compression from an obstructed intake valve. Contributing to the accident was the pilot’s decision to shut down the engine while in flight.May 16, 2009 · N738LF · Substantial damageNTSB WPR09LA237Accident · No injuriesLimited investigationFinal reportCessna U206E · Oroville, CAA total loss of engine power during cruise flight due to an excessively lean mixture for undetermined reasons.May 10, 2009 · N1457M · Substantial damageNTSB WPR09LA230Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Santa Rosa, CAA total loss of engine power on final approach for undetermined reasons.May 7, 2009 · N2722T · Substantial damageNTSB WPR09LA215Accident · No injuriesLimited investigationFinal reportStanton Glastar · Redding, CAA loss of engine power during cruise for undetermined reasons.Apr 25, 2009 · N518PV · Substantial damageNTSB WPR09LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hanford, CAA loss of engine power during descent due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to use the correct fuel flow performance chart.Apr 24, 2009 · N6584B · Substantial damageNTSB WPR09LA208Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Groveland, CAA loss of engine power for undetermined reasons.Apr 22, 2009 · N8124R · Substantial damageNTSB WPR09LA195Accident · Serious injuriesLimited investigationFinal reportSungkwon Kim LONG-EZE · Dunsmuir, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.Apr 14, 2009 · N342MS · Substantial damageNTSB WPR09LA177Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Baker, CAA total loss of engine power for undetermined reasons.Apr 2, 2009 · N222G · Substantial damageNTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.Mar 28, 2009 · N2445S · Substantial damageNTSB WPR09LA166Accident · Serious injuriesLimited investigationFinal reportReimus Sonex FR1 · Paso Robles, CAA total loss of engine power during cruise flight due to the pilot/builder’s failure to follow the engine manufacturer’s maintenance instructions and apply the correct torque to the rocker arm nuts during maintenance.Mar 25, 2009 · N1006N · Substantial damageNTSB WPR09LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Firebaugh, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning and monitoring.Mar 24, 2009 · N1857H · Substantial damageNTSB WPR09LA161Accident · No injuriesLimited investigationFinal reportBrown Barnett J4B · Sheridan, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Mar 20, 2009 · N35JB · Substantial damageNTSB WPR09LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Oceanside, CAA total loss of engine power in flight due to the fatigue failure of the No. 4 cylinder.Mar 8, 2009 · N2478B · Substantial damageNTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.Mar 3, 2009 · N9166E · Substantial damageNTSB WPR09CA137Accident · No injuriesData collectionFinal reportRudolph Ralph Monroe Starlite · Coachella, CAA total loss of engine power due to oil starvation to the rear crankshaft journal.Mar 2, 2009 · N180RR · 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 WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.Feb 18, 2009 · N48761 · 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 damageNTSB WPR09FA102Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF-260C · Santa Monica, CAThe pilot’s failure to select the proper fuel tank for takeoff, which resulted in a loss of engine power. Contributing to the accident was the pilot's failure to maintain aircraft control while attempting a return to runway maneuver.Jan 29, 2009 · N688C · Substantial damageNTSB WPR09CA091Accident · No injuriesData collectionFinal reportSiemer James H Earthstar · Santa Ynez, CAA partial loss of engine power due to the rear cylinder's spark plug coming out of the cylinder head.Jan 18, 2009 · N532JS · Substantial damageNTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.Jan 14, 2009 · N3129 · Substantial damageNTSB WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.Jan 11, 2009 · N21999 · Substantial damageNTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.Jan 10, 2009 · N758FN · Substantial damageNTSB 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 WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.Dec 1, 2008 · N3058Y · Substantial damageNTSB WPR09LA047Accident · Serious injuriesLimited investigationFinal reportNickel RV-6 · Fresno, CAThe loss of engine power during initial climb for undetermined reasons.Nov 25, 2008 · N6TR · Substantial damageNTSB WPR09LA025Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Rialto, CAA total loss of engine power during initial climb due to an interruption in fuel flow through an improperly assembled carburetor.Oct 26, 2008 · N44848 · Substantial damageNTSB WPR09FA015Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Markleeville, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to choose a suitable landing area.Oct 16, 2008 · N9581C · Substantial damageNTSB 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 LAX08CA295Accident · Minor injuriesData collectionFinal reportMiltenberger Family Fun · Adin, CAThe loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.Sep 10, 2008 · N903PD · 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 SEA08LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Burbank, CAThe pilot's improper preflight and in-flight planning, which resulted in fuel exhaustion. Contributing to the accident were the pilot's loss of situational awareness while conducting the normal and emergency checklists during his turn from base to final…Aug 30, 2008 · N172ST · Substantial damageNTSB LAX08LA263Accident · Serious injuriesLimited investigationFinal reportSmith Stewart S51D · Oxnard, CAThe loss of engine power for an undetermined reason.Aug 9, 2008 · N51VS · Substantial damageNTSB LAX08LA251Accident · No injuriesLimited investigationFinal reportCessna TU206E · Murrieta, CAA malfunction of the flight control system and loss of engine power for undetermined reasons.Jul 31, 2008 · N1499M · Substantial damageNTSB LAX08LA242Accident · No injuriesLimited investigationFinal reportGlaser-Dirks Flugzeugbau DG-100G · Truckee, CAA malfunction of the tow release mechanism.Jul 23, 2008 · N132S · Substantial damageNTSB LAX08CA228Accident · No injuriesData collectionFinal reportSchweizer G-164B · Alturas, CAA total loss of engine power due to fuel starvation, which resulted from a fuel system contamination and a clogged fuel filter. Contributing to the accident was the rough terrain.Jul 13, 2008 · N3633B · Substantial damageNTSB LAX08CA224Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Camarillo, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 10, 2008 · N7471D · Substantial damageNTSB LAX08LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAA partial loss of engine power due to the disconnection of the throttle control cable from the throttle arm due to the operator's improper maintenance. Contributing to the accident was unsuitable terrain for a forced landing.Jul 9, 2008 · N9627B · Substantial damageNTSB LAX08CA214Accident · No injuriesData collectionFinal reportCessna 172F · Pomona, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the airplane.Jul 6, 2008 · N8881U · Substantial damageNTSB LAX08CA215Accident · Minor injuriesData collectionFinal reportCessna 150J · Seal Beach, CAFuel starvation due to the pilot's improper fuel management procedures and failure to select a tank containing fuel. Contributing to the accident was the lack of suitable terrain for the forced landing.Jul 4, 2008 · N60486 · Substantial damageNTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.Jun 30, 2008 · N61736 · Substantial damageNTSB LAX08LA206Accident · No injuriesLimited investigationFinal reportCessna 172N · El Cajon, CAThe loss of engine power due to carburetor ice resulting from the flight instructor's failure to use the carburetor heat when simulating an engine failure. Contributing to the accident were the carburetor icing weather condition and the lack of suitable…Jun 26, 2008 · N6360D · Substantial damageNTSB LAX08LA187Accident · No injuriesLimited investigationFinal reportCessna R172K · Big Bear City, CAThe pilot's failure to attain and maintain an adequate airspeed that led to a stall/mush. Contributing to the accident was the lack of suitable terrain for an off airport landing and a high density altitude.Jun 21, 2008 · N758DH · Substantial damageNTSB LAX08LA183Accident · Minor injuriesLimited investigationFinal reportRobinson R44 II · Topanga, CAThe in-flight separation of the tail rotor gear box for an undetermined reason. Contributing to the accident was the hilly terrain, which was unsuitable for a forced landing.Jun 15, 2008 · N168AG · Substantial damageNTSB SEA08MA136Accident · 3 fatalMajor investigationFinal reportAerospatiale AS-350-D · Avalon, CALoss of engine power during approach for landing due to a fatigue fracture of a power turbine blade.May 24, 2008 · N67GE · DestroyedNTSB LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.May 2, 2008 · N7059E · Substantial damageNTSB LAX08LA089Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Redding, CAA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel tank selector.Mar 30, 2008 · N95ME · Substantial damage