NTSB investigations, 2009

260 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 year(c.\"eventDate\") = 2009
    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 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 ERA09LA532Accident · No injuriesLimited investigationFinal reportRyan Navion · Fire Island, NYA total loss of engine power during cruise flight due to fuel starvation as a result of a deteriorated fuel gasket.Sep 20, 2009 · N4467K · Substantial damageNTSB CEN09IA595Incident · No injuriesIncident investigationFinal reportBeech V35 · Nacogdoches, TXThe complete loss of engine power due to failure of the number two connecting rod. The reason for the connecting rod failure could not be determined.Sep 20, 2009 · N97500 · Minor damageNTSB WPR09LA458Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Reno, NVThe loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.Sep 19, 2009 · C-FDXO · Substantial damageNTSB WPR09LA454Accident · Minor injuriesLimited investigationFinal reportLewis Jennings Nieuport 11 · Pahrump, NVA total loss of engine power during cruise flight due to a failure of the engine's sole magneto.Sep 18, 2009 · N124LH · Substantial damageNTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.Sep 17, 2009 · N308BG · 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 ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.Sep 15, 2009 · N336DN · DestroyedNTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.Sep 13, 2009 · N734TV · Substantial damageNTSB CEN09CA584Accident · Minor injuriesData collectionFinal reportYates W/Lazar M Safari Helicopter · Cedar Park, TXAn in-flight separation of the tail rotor blades and the tail rotor gearbox for undetermined reasons.Sep 13, 2009 · N555BB · Substantial damageNTSB WPR09LA446Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-1B · Creswell, ORA partial loss of engine power due to the malfunction of the engine's right magneto.Sep 12, 2009 · N9682L · Substantial damageNTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.Sep 9, 2009 · N94741 · 2 aircraft · Substantial damageNTSB ERA09LA510Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampi · Milner, GAThe failure of the No. 3 cylinder exhaust valve for undetermined reasons.Sep 8, 2009 · N135ER · Substantial damageNTSB CEN09LA574Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Kimball, NEA loss of engine power due to improper installation of an oil line fitting resulting in oil depletion.Sep 8, 2009 · N6761Q · Substantial damageNTSB CEN09CA563Accident · Minor injuriesData collectionFinal reportHalbert James H Rans S-7 · Short, OKA partial loss of engine power for undetermined reasons.Sep 6, 2009 · N615JH · DestroyedNTSB ERA09LA511Accident · Minor injuriesLimited investigationFinal reportAir Creation 582SL · Strafford, NHA loss of engine power for undetermined reasons.Sep 5, 2009 · N699AC · 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 ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.Sep 4, 2009 · N517P · Substantial damageNTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.Sep 2, 2009 · N58163 · Substantial damageNTSB ERA09LA496Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Mansfield, MAA loss of engine power due to carburetor icing as a result of the pilot's delayed use of carburetor heat.Sep 1, 2009 · N32146 · Substantial damageNTSB ERA09LA491Accident · Minor injuriesLimited investigationFinal reportMyers Donald E Kitfox 4 · Flintstone, MDA total loss of engine power due to the lack of sufficient lubrication and the pilot/owner’s failure to adequately service the airplane’s engine.Aug 30, 2009 · N69377 · Substantial damageNTSB CEN09WA607Accident · No injuriesForeign investigationEurocopter AS350 B2 · Némisko, CanadaOn August 28, 2009, at 1200 eastern daylight time, a Eurocopter model AS350 B2 (AStar), s/n 3292, Canadian registration C-FHAP, experienced a loss of engine power during cruise flight near Némisko, Québec, Canada. The helicopter was substantially damaged…Aug 28, 2009 · C-FHAP · Substantial damageNTSB WPR09LA422Accident · No injuriesLimited investigationFinal reportCessna 210K · Show Low, AZA total loss of engine power due to the displaced oil filter adapter gasket, which resulted in an oil leak and oil exhaustion. Contributing to the accident was the unsuitable terrain for a forced landing.Aug 27, 2009 · N4600Q · Substantial damageNTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…Aug 27, 2009 · N4837T · Substantial damageNTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.Aug 27, 2009 · N7339Z · Substantial damageNTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.Aug 27, 2009 · N33078 · Substantial damageNTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.Aug 26, 2009 · N186CF · Substantial damageNTSB CEN09LA551Accident · No injuriesLimited investigationFinal reportWeber Pelican · Searcy, ARA total loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.Aug 26, 2009 · N713DW · Substantial damageNTSB ERA09LA481Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rockaway, NJA total loss of engine power due to oil starvation for undetermined reasons.Aug 25, 2009 · N6117R · Substantial damageNTSB 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 ERA09LA477Accident · Serious injuriesLimited investigationFinal reportVollenweider R/Hurst R F Vans RV-9A · Marianna, FLFailure of the propeller speed reduction gearbox for undetermined reasons. Contributing to the accident was the pilot’s decision to disregard the manufacturer's mandate to replace the gearbox, the manufacturer's failure to provide owners with technical…Aug 23, 2009 · N362TS · Substantial damageNTSB ERA09CA479Accident · No injuriesData collectionFinal reportJonker JS-1B · Tullahoma, TNThe pilot's failure to maintain a proper glidepath while on approach, resulting in landing short of the runway.Aug 23, 2009 · N504BT · Substantial damageNTSB CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.Aug 23, 2009 · N171WR · Substantial damageNTSB ERA09LA476Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fairmount, GAA total loss of engine power due to fuel starvation as a result of a contaminated fuel strainer.Aug 22, 2009 · N61022 · Substantial damageNTSB CEN09LA602Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · New Miner, WIA total loss of engine power due to the fatigue failure of the engine torsion shaft. Contributing to the accident was the chrome plating of the shaft by an undetermined maintenance/overhaul facility.Aug 22, 2009 · N3651R · Substantial damageNTSB WPR09CA415Accident · No injuriesData collectionFinal reportPaul B. Johnson Avid Mark IV · Nampa, IDThe airplane's encounter with tall vegetation that ensnared the landing gear during an off-field precautionary landing.Aug 21, 2009 · N333PD · Substantial damageNTSB ERA09LA473Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Okeechobee, FLA total loss of engine power during initial climb for undetermined reasons.Aug 21, 2009 · N535CT · Substantial damageNTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.Aug 20, 2009 · N4842R · Substantial damageNTSB CEN09CA535Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Leland, ILA total loss of engine power in flight due to a loss of engine oil as a result of the separation of the propeller hub components for undetermined reasons.Aug 17, 2009 · N73102 · Substantial damageNTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.Aug 16, 2009 · N47539 · Substantial damageNTSB CEN09CA531Accident · Serious injuriesData collectionFinal reportFisher Michael H T-BIRD II · Dundee, OHA total loss of engine power due to the failure of the outer crankshaft seal.Aug 16, 2009 · N5559A · Substantial damageNTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Aug 13, 2009 · N99BE · Substantial damageNTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.Aug 12, 2009 · N86GW · Substantial damageNTSB ERA09LA460Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Acworth, GAThe loss of engine power due to the fatigue failure of the third-stage turbine wheel airfoil.Aug 12, 2009 · N527BB · Substantial damageNTSB CEN09CA517Accident · No injuriesData collectionFinal reportBell 47G-2A · Covert, MIA loss of engine power due to fuel starvation as a result of blocked fuel vents.Aug 11, 2009 · N9526 · Substantial damageNTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.Aug 8, 2009 · N569WT · Substantial damageNTSB ERA09LA448Accident · 2 fatalLimited investigationFinal reportKociemba Robert H T-Bird II · Keymar, MDThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination.Aug 8, 2009 · N90458 · Substantial damageNTSB ERA09LA446Accident · No injuriesLimited investigationFinal reportLobb Kenneth CH 701 · Murfreesboro, TNA total loss of engine power due to the improper installation of the alternator drive gear.Aug 7, 2009 · N75644 · Substantial damageNTSB WPR09LA390Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Eatonville, WAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management. Contributing to the accident was the airplane's lack of an interconnected fuel vent system.Aug 6, 2009 · N28425 · Substantial damageNTSB CEN09LA501Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Oklahoma City, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.Aug 6, 2009 · N4554V · Substantial damage