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 NYC08CA268Accident · Minor injuriesData collectionFinal reportCessna 182L · Westerly, RIA loss of power due to a partial blockage of the air induction system.Aug 2, 2008 · N42366 · Substantial damageNTSB MIA08LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Kingston, RIThe pilot's misjudgment of speed and altitude while maneuvering to land during an emergency descent. Contributing to the accident was the partial loss of engine power.Aug 2, 2008 · N56064 · Substantial damageNTSB MIA08CA154Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mc Kinnon, TNThe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.Aug 2, 2008 · N4377J · Substantial damageNTSB CHI08LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Tomahawk, WIA total loss of engine power due to a loss of all of the engine's oil as a result of the safety wire on the governor idler gear shaft's oil plug breaking, leading to the oil plug coming unscrewed. Contributing to the accident was the lack of a suitable area…Aug 2, 2008 · N6520R · Substantial damageNTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.Aug 1, 2008 · N227RD · 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 CHI08CA217Accident · No injuriesData collectionFinal reportGrumman G-164A · Veedersburg, INThe oil filler cap not reinstalled by the pilot prior to the aerial application flight and the total loss of engine oil during an aerial application. Additional causes were the low altitude of the operation and the unsuitable terrain encountered by the pilot…Jul 28, 2008 · N9892 · Substantial damageNTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.Jul 25, 2008 · N2330Y · Substantial damageNTSB CHI08CA210Accident · No injuriesData collectionFinal reportBell 47G-3B-2 · Lafetyette, INThe loss of engine power during an aerial application flight due to a fatigue fracture of the carburetor heat control valve spring and the inadequate maintenance inspection by the pilot/mechanic. An additional cause was the low altitude of the operation.Jul 24, 2008 · N4029G · 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 DEN08LA128Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Longmont, COA total loss of engine power for reasons undetermined. Contributing to the accident was the unsuitable terrain on which to make a forced landing.Jul 23, 2008 · N7965M · Substantial damageNTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…Jul 22, 2008 · N3990C · Substantial damageNTSB LAX08LA240Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Bountiful, UTA partial loss of engine power for undetermined reasons.Jul 22, 2008 · N7672 · Substantial damageNTSB CHI08CA226Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIA loss of engine power for an undetermined reason.Jul 22, 2008 · N9483L · Substantial damageNTSB DFW08CA192Accident · No injuriesData collectionFinal reportGrumman G-164A · Bovina, TXLoss of engine power for undetermined reasons.Jul 18, 2008 · N7832 · Substantial damageNTSB CHI08CA199Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Bryan, OHThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations. A contributing factor was the inaccurate fuel gauge.Jul 18, 2008 · N8814L · Substantial damageNTSB NYC08LA251Accident · No injuriesLimited investigationFinal reportHolmes Arthur Orman Kitfox IV · Burkesville, KYThe total loss of engine power due to the installation of an engine oil filter that did not meet the engine manufacture's specifications.Jul 17, 2008 · N70694 · Substantial damageNTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.Jul 15, 2008 · N4287Z · Substantial damageNTSB MIA08CA140Accident · Minor injuriesData collectionFinal reportQuad City Ultralight Challenger II · Windslow Twp, NJThe pilot's inaccurate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.Jul 13, 2008 · N2785A · 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 NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.Jul 12, 2008 · N7395 · Substantial damageNTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.Jul 12, 2008 · N583AF · Substantial damageNTSB DFW08CA183Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Denton, TXThe pilot's inadequate fuel management, which resulted in fuel starvation and the subsequent loss of engine power.Jul 11, 2008 · N9678U · 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 DFW08CA180Accident · Minor injuriesData collectionFinal reportMooney M20 · Rogers, ARThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning/decision.Jul 9, 2008 · N7072V · Substantial damageNTSB NYC08FA242Accident · Minor injuriesField investigationFinal reportBeech V35B · Lancaster, PAA complete loss of engine power for undetermined reasons.Jul 8, 2008 · N9438Q · Substantial damageNTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.Jul 8, 2008 · N8647G · DestroyedNTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…Jul 6, 2008 · N7360J · 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 MIA08LA133Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Colquitt, GALoss of engine power due to the installation of incorrect turbine blades on the compressor turbine disk during repair of the disk assembly.Jul 5, 2008 · N8499V · 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 DFW08LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Stotesbury, MOFracture of the engine's number eight cylinder barrel resulting in a loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.Jul 3, 2008 · N520Y · DestroyedNTSB CHI08CA183Accident · No injuriesData collectionFinal reportChallenger II · Williamsfield, ILThe loss of engine power for undertermined reasons and the unsuitable landing area encountered during the forced landing. Contributing to the accident were the trees and the residence.Jul 3, 2008 · N23764 · Substantial damageNTSB CHI08LA180Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar 601P · Alexandria, MNThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for the forced landing.Jul 2, 2008 · N601TS · Substantial damageNTSB CHI08CA175Accident · No injuriesData collectionFinal reportBeech A36 · Dwight, ILThe loss of engine power for undetermined reasons. Contributing to the accident was the highway signpost that the airplane impacted during the landing rollout.Jul 1, 2008 · N6051M · Substantial damageNTSB SEA08LA156Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Bend, ORThe failure of the crankshaft during cruise flight due to fatigue.Jun 30, 2008 · N7XZ · 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 ERA09CA543Accident · No injuriesData collectionFinal reportPiper J3C-65 · Rosedale, MSThe failure of the pilots to maintain airspeed following a reported partial loss of engine power.Jun 28, 2008 · N42156 · Substantial damageNTSB CHI08CA194Accident · Minor injuriesData collectionFinal reportCessna 150F · Johannesburg, MIThe pilot's failure to recognize the onset of carburetor icing resulting in a loss of engine power and the unsuitable terrain encountered during the forced landing. Contributing to the accident were the carburetor icing conditions, and the rough terrain.Jun 28, 2008 · N7886F · 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 NYC08CA288Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Carrollton, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and subsequent loss of engine power.Jun 25, 2008 · N26316 · Substantial damageNTSB DFW08LA169Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olathe, KSA loss of engine power for undetermined reasons.Jun 24, 2008 · N28HN · Substantial damageNTSB ANC08LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKA loss of engine power for an undetermined reason during an approach for landing, which resulted in a forced landing and collision with terrain.Jun 24, 2008 · N3236P · Substantial damageNTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.Jun 22, 2008 · N757HA · Substantial damageNTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.Jun 22, 2008 · N6144J · 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 DEN08LA108Accident · No injuriesLimited investigationFinal reportMercer Avid Flyer Mk IV · Augusta, KSFailure of the engine cooling system's thermostat, causing the engine to overheat and seize. Contributing to the accident was the fence.Jun 21, 2008 · N6880L · Substantial damageNTSB DEN08LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Garwood, TXA loss of engine power due to the total failure of the number 2 cylinder.Jun 19, 2008 · N3166H · DestroyedNTSB NYC08CA217Accident · Minor injuriesData collectionFinal reportSchleicher ASW-27B · Warren, VTThe pilot's delayed decision to divert to a suitable landing area.Jun 17, 2008 · N227K · Substantial damage