NTSB investigations, 2008

198 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\") = 2008
    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 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 DEN08LA103Accident · No injuriesLimited investigationFinal reportCessna A188B · Lyons, KSthe loss of engine power for undetermined reasons. A contributing factor was the dirt embankment.Jun 12, 2008 · N9639G · Substantial damageNTSB LAX08LA168Accident · No injuriesLimited investigationFinal reportMkii Lancair Legacy 2000 · Bend, ORA total loss of engine power due to the fatigue failure of the Number 3 cylinder connecting rod.Jun 9, 2008 · N199L · Substantial damageNTSB CHI08LA154Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MNA loss of engine thrust due to the propeller separating from the aircraft as a result of fatigue failure of the propeller attachment bolts caused by the insufficient torque of the bolts during installation.Jun 9, 2008 · N7214Y · Substantial damageNTSB ANC08LA074Accident · No injuriesLimited investigationFinal reportLake L-4 · Girdwood, AKA partial loss of engine power for an undetermined reason, which resulted in a forced landing. Contributing to the accident was rough and uneven terrain.Jun 9, 2008 · N13RZ · Substantial damageNTSB NYC08CA208Accident · Minor injuriesData collectionFinal reportCessna 177RG · Bessemer, ALFailure of the left magneto for undetermined reasons resulting in a partial loss of engine power during takeoff.Jun 8, 2008 · N45133 · Substantial damageNTSB NYC08LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Brockport, NYA total loss of engine power due to fuel exhaustion as a result of the flight instructor's inadequate preflight planning.Jun 1, 2008 · N3910R · Substantial damageNTSB CHI08LA144Accident · No injuriesLimited investigationFinal reportCessna 208B · Greensburg, INThe total loss of engine power during the en route climb due to a compressor turbine failure as a result of blade creep. Also causal was the inadequate maintenance performed by the airplane's owner.Jun 1, 2008 · N102VE · Substantial damageNTSB NYC08LA196Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Romney, WVA partial loss of engine power during takeoff due to failure of the left magneto. Contributing to the accident was unsuitable terrain to conduct a forced landing.May 25, 2008 · N46996 · 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 NYC08CA192Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Millinocket, METhe pilot’s failure to properly monitor fuel consumption during the flight.May 24, 2008 · N4823S · Substantial damageNTSB LAX08LA153Accident · No injuriesLimited investigationFinal reportCessna P210N · Peach Springs, AZA loss of engine power due to induced catastrophic internal failure of the engine as a result of the displacement and rotation of the number 2 main bearing that resulted in a fatigue fracture of the crankshaft.May 23, 2008 · N4753K · Substantial damageNTSB DEN08LA095Accident · No injuriesLimited investigationFinal reportDowner Bellanca 14-19-3 · N. Little Rock, ARThe loss of engine power due to the incorrect and improper installation of throttle and mixture cables by unknown maintenance personnel.May 23, 2008 · N7640E · Substantial damageNTSB LAX08LA145Accident · No injuriesLimited investigationFinal reportBabcock KR-2 · Olympia, WAA total loss of engine power during takeoff due to the carburetor's mixture needle backing out.May 19, 2008 · N4276Y · Substantial damageNTSB NYC08FA184Accident · 2 fatalField investigationFinal reportCessna 337A · West Creek, NJThe pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…May 17, 2008 · N5382S · Substantial damageNTSB LAX08LA139Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kekaha, HIA loss of engine power for undetermined reasons.May 14, 2008 · N530R · Substantial damageNTSB DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.May 8, 2008 · N385WR · Substantial damageNTSB ANC08LA063Accident · Serious injuriesLimited investigationFinal reportShaffstall Kolb Firestar II · Concord, NCA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with terrain.May 6, 2008 · N40737 · Substantial damageNTSB LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.May 5, 2008 · N6320B · Substantial damageNTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.May 4, 2008 · N104HC · Substantial damageNTSB 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 DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.Apr 18, 2008 · N56895 · DestroyedNTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.Apr 15, 2008 · N8442Y · Substantial damageNTSB LAX08LA098Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Kingman, AZA total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.Apr 11, 2008 · N9022N · Substantial damageNTSB DFW08LA095Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G36 · El Dorado, KSThe improper installation of the fuel manifold valve's brass plug. Contributing to the accident was the unsuitable landing area for the forced landing.Apr 9, 2008 · N984W · Substantial damageNTSB CHI08LA104Accident · No injuriesLimited investigationFinal reportVic Tatelman Baby Belle · Lakeland, FLThe failure of the tailrotor driveshaft hanger bearing and jamming of the tailrotor.Apr 9, 2008 · N6261N · Substantial damageNTSB DFW08LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quinton, OKAn undetermined mechanical malfuction associated with the tail rotor drive system which led to a loss of control.Apr 7, 2008 · N34SD · Substantial damageNTSB SEA08LA104Accident · No injuriesLimited investigationFinal reportRobinson R44 · Pahrump, NVThe loss of the engine to transmission drive train continuity while on approach for undetermined reasons. Contributing to the accident were lack of suitable terrain for a run-on landing, and cars on the race track.Apr 5, 2008 · N510JM · Substantial damageNTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.Apr 5, 2008 · N402PD · 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 damageNTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.Mar 29, 2008 · N4839P · Substantial damageNTSB LAX08LA088Accident · Minor injuriesLimited investigationFinal reportBeech F33A · San Diego, CAA loss of engine power due to fuel starvation as a result of the pilot's improper use of the mixture control.Mar 28, 2008 · N3133W · Substantial damageNTSB NYC08LA137Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Middlesboro, KYThe mechanic's improper maintenance installation of the No. 1 cylinder rocker arms which led to oil starvation and a loss of engine power.Mar 13, 2008 · N6651F · Substantial damageNTSB NYC08CA132Accident · No injuriesData collectionFinal reportRotorway 162F · Cartersville, GAThe owner/builder's improper installation of the foot pedal scissor beam, which resulted in its failure during hover flight.Mar 9, 2008 · N831MS · Substantial damageNTSB SEA08LA084Accident · Serious injuriesLimited investigationFinal reportRaytheon B36TC · Mammoth, CAA loss of engine power for undetermined reasons. Contributing to the accident was dense snow covering the level terrain.Mar 3, 2008 · N234MT · Substantial damageNTSB LAX08LA066Accident · Serious injuriesLimited investigationFinal reportBartle Lancair IV-P · Murrieta/Temecu, CAA total loss of engine power while on approach due to the electrical overload of a fuse caused by the builder's inadequate design and installation of the electrical ignition system.Feb 26, 2008 · N811HB · Substantial damageNTSB NYC08LA106Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Pahokee, FLThe pilot's decision to depart with a known deficiency with the engine, which resulted in a loss of engine power. Contributing to the accident was the loss of engine power due to the failure of the engine-driven fuel pump.Feb 20, 2008 · N36GJ · Substantial damageNTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.Feb 10, 2008 · N9047W · Substantial damageNTSB LAX08LA056Accident · No injuriesLimited investigationFinal reportSmith Zodiac 601XL · Murrieta, CAA loss of engine power due to fuel starvation, which was induced by the electrical system lacking sufficient power to run all of the electrical devices on the airplane and the electrical fuel pump.Feb 1, 2008 · N601KS · Substantial damageNTSB DFW08LA058Accident · No injuriesLimited investigationFinal reportPiper PA32-301FT · Wiggins, MSThe failure of the fuel servo gasket and subsequent partial loss of engine power. Contributing to the accident was the none-suitable terrain for the forced landing.Jan 28, 2008 · N1053F · Substantial damageNTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.Jan 25, 2008 · N1939T · Substantial damageNTSB DEN08LA054Accident · No injuriesLimited investigationFinal reportMacAdams Titan Tornado 912 · Rock Springs, WYThe loss of engine power for undetermined reasons. Contributing to the accident was the snow covered ravine.Jan 24, 2008 · N142TT · Substantial damageNTSB MIA08LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Kissimmee, FLThe probable cause of this accident is undetermined.Jan 20, 2008 · N8JZ · Substantial damageNTSB MIA08LA041Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Norwood, MAThe loss of engine power for undetermined reasons. *This report was modified on May 20, 2008.*Jan 17, 2008 · N414DJ · Substantial damageNTSB ANC08LA032Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Aniak, AKA partial loss of engine power for an undetermined reason. Contributing to the accident were the pilot's inadvertent encounter with IMC conditions, and a whiteout during his attempted go-around from an emergency landing approach.Jan 16, 2008 · N1701U · Substantial damageNTSB NYC08CA083Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Fenner, NYThe pilot's delayed decision to perform a precautionary landing. Contributing to the accident was the reduced visibility in snow and the soft terrain.Jan 15, 2008 · N122AA · Substantial damageNTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.Jan 13, 2008 · N7243V · Substantial damageNTSB NYC08LA077Accident · No injuriesLimited investigationFinal reportBell 407 · DeLand, FLA total loss of engine power due to the fatigue failure of a third stage turbine wheel blade.Jan 7, 2008 · N801DS · Substantial damage