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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.NTSB SEA08LA206Accident · No injuriesLimited investigationFinal reportStearman C3-B · Stevenson, WAA loss of engine power due to fuel starvation from a piece of disintegrating gasket material that was blocking the fuel jet. Also causal was the failure of maintenance personnel to verify the condition of the gaskets when the carburetor was examined prior to…NTSB ANC08LA126Accident · No injuriesLimited investigationFinal reportPiper PA-19 · Palmer, AKA total loss of engine power for an undetermined reason.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.NTSB CHI08IA294Incident · No injuriesIncident investigationFinal reportIndus T-211 Thorpedo · La Porte, INA loss of engine power due to fuel exhaustion as a result of siphoning from the fuel filler neck and cap. Contributing to the incident were the fuel over-servicing which resulted in the siphoning condition, and the ASTM standards which allowed for the fuel…NTSB CHI08CA290Accident · No injuriesData collectionFinal reportUnknown Supercat · Redding, IAThe pilot's failure to properly manage the fuel supply of the airplane which resulted in fuel exhaustion. Contributing to the accident was the hilly terrain encountered during the subsequent forced landing.NTSB CHI08CA284Accident · No injuriesData collectionFinal reportFleet 2 · Leroy, OHThe loss of engine power due to the propeller hub failure during a low-level maneuver. Contributing to the accident were the trees encountered during the forced landing.NTSB CHI08CA283Accident · Minor injuriesData collectionFinal reportMooney M20C · Bolingbrook, ILThe non-mechanical loss of engine power due to the pilot's incorrect positioning of the fuel tank selector prior to takeoff and the subsequent fuel starvation during takeoff.NTSB 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.NTSB 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.NTSB CHI08CA280Accident · Minor injuriesData collectionFinal reportCessna 150G · Urbana, OHA loss of engine power due to carburetor ice. Contributing to the accident were environmental conditions conducive to carburetor icing.NTSB ANC08CA121Accident · No injuriesData collectionFinal reportCessna 170 · Ruby, AKThe pilot's failure to use carburetor heat, while operating at a reduced engine power while maneuvering in carburetor icing conditions.NTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.NTSB CHI08LA274Accident · Minor injuriesLimited investigationFinal reportSadler Vampire · Findlay, OHA total loss of engine power due to the failure of the reduction drive assembly as a result of excessive wear and high temperatures. Contributing to the accident were the pilot's lack of total experience in the airplane and the unsuitable terrain for a forced…NTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.NTSB SEA08LA193Accident · Serious injuriesLimited investigationFinal reportWasson Loehle Loehle P-40 · Oregon City, ORThe loss of total engine power due to a cold seizure.NTSB 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…NTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.NTSB MIA08CA178Accident · No injuriesData collectionFinal reportDehavilland DH82A · Sevierville, TNThe failure of the wooden propeller.NTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.NTSB CHI08CA266Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Jasper, MNThe pilot's failure to assure the primer control was locked during the aircraft preflight. Factors associated with the accident were the low altitude at which the airplane was operating, the fence, the roadway, and the ditch.NTSB CHI08CA264Accident · No injuriesData collectionFinal reportCessna 172 · Pullman, MIA complete loss of engine power for undetermined reasons. A contributing factor was the rough terrain encountered during the forced landing.NTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.NTSB DFW08CA211Accident · No injuriesData collectionFinal reportMurray Frank H DA5B · Odessa, TXFailure of the intake manifold when the flexible connectors disconnected from the carburetor after a turbulence encounter. Contributing to the accident was insuitable terrain for a forced landing.NTSB LAX08LA271Accident · No injuriesLimited investigationFinal reportHawker Sea Fury TMK 20 · Reno, NVA ruptured center balance diaphragm that resulted in a loss of engine power during final approach and subsequent forced landing on a desert floor.NTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.NTSB LAX08LA269Accident · No injuriesLimited investigationFinal reportCessna TU206F · Glendale, AZA loose fuel line fitting that resulted in a partial loss of engine power during the initial takeoff climb. Contributing to the accident was inadequate maintenance installation of the fitting.NTSB SEA08CA184Accident · No injuriesData collectionFinal reportWheat Excalibur EX · Moses Lake, WAThe right rudder pedal attach rivets sheared due to overload.NTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.NTSB NYC08LA280Accident · Minor injuriesLimited investigationFinal reportSocata MS894A · Fulton, NYA loss of engine power due to fatigue failure of the crankshaft and the No. 3 engine cylinder connecting rod as a result of improper machining of the engine crankshaft during engine overhaul by maintenance personnel.NTSB LAX08LA268Accident · No injuriesLimited investigationFinal reportRouse Glasair III · Reno, NVThe excessively worn throttle/mixture linkage arms and pins and a missing mixture control linkage spring washer, which resulted in a loss of power due to an excessively rich mixture.NTSB CHI08CA257Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Luverne, MNThe failure of the compressor turbine blades which resulted in the loss of power. Factors associated with the accident were the low altitude and the trees.NTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.NTSB DFW08CA207Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Abbeville, LAA total loss of engine power for undetermined reasons. Contributing to the accident was unsuitable terrain for a forced landing.NTSB SEA08CA177Accident · Minor injuriesData collectionFinal reportAnglin RV-6 · Puyallup, WAThe complete loss of engine power for undetermined reasons. Contributing to the accident were hidden obstructions (tree stumps) in the field of long grass within which the pilot executed his forced landing.NTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.NTSB CHI08CA213Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Ida Grove, IAA failure of the turbocharger blower which resulted in the partial loss of power. Factors associated with the accident were the low altitude of the airplane and the embankment.NTSB NYC08FA292Accident · No injuriesField investigationFinal reportSteven A. Jones Lancair IV P · Stafford, VAThe pilot's decision to install voltage regulators in the engine compartment where they were susceptible to water intrusion, which resulted in a malfunction of the standby electrical system's voltage regulator and a subsequent in-flight fire.NTSB DEN08LA138Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Heber Springs, ARthe improper installation of the PC line on the engine which resulted in a partial loss of engine power. Contributing to the accident was the trees encountered during the forced landing.NTSB NYC08CA275Accident · Serious injuriesData collectionFinal reportI.C.A.-Brasov IS-26B2 · Fincastle, VAThe pilot's geographic disorientation, which resulted in an off-airport landing. Contributing to the accident was the pilot's selection of an inadequate landing site.NTSB CHI08CA250Accident · No injuriesData collectionFinal reportPiper J-3 · North Branch, MNThe loss of engine power as a result of oil starvation to the number one rod bearing and number one connecting rod. Contributing to the accident was the rough terrain.NTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.NTSB LAX08LA263Accident · Serious injuriesLimited investigationFinal reportSmith Stewart S51D · Oxnard, CAThe loss of engine power for an undetermined reason.NTSB CHI08CA242Accident · No injuriesData collectionFinal reportSchweizer G-164A · Jefferson, IAThe loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.NTSB SEA08CA172Accident · Serious injuriesData collectionFinal reportLyons Navajo HKS · Waterville, WAThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was a microburst condition.NTSB CHI08CA240Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Salem, IAThe loss of engine power for an undetermined reason. Contributing to the accident was the high grass encountered during the landing roll.NTSB DEN08CA135Accident · No injuriesData collectionFinal reportGrumman G-164A · Walsh, COThe total failure of a cylinder head assembly. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN08CA134Accident · No injuriesData collectionFinal reportEnstrom 280FX · Aurora, COThe pilot's improper planning and decision making resulting in the loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's premature application of collective resulting in a hard landing and substantial damage.NTSB MIA08LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Oxford, MSA loss of engine power due to fuel starvation as a result of maintenance personnel's failure to tighten a fuel line fitting.NTSB ANC08LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Aniak, AKA partial loss of engine power during takeoff due to a failure of the left engine's turbocharger as a result of the failure of a turbine shaft bearing. Contributing to the accident was unsuitable terrain for a forced landing.