NTSB investigations
3,368 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.\"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 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 ERA19LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Meriden, CTThe loss of engine power for undetermined reasons.NTSB ERA19LA143Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Edgefield, SCThe total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.NTSB CEN19LA132Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Prairieville, LAInstallation of an incorrect engine oil drain valve, which resulted in damage to the valve during landing gear retraction and subsequent engine failure due to oil starvation. Contributing to the accident was the failure of maintenance personnel to comply with…NTSB ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…NTSB ERA19LA139Accident · No injuriesClass 3 · LimitedFinal reportMarlow Bearhawk · Sevierville, TNAbnormal combustion in the No. 1 cylinder for reasons that could not be determined based on the available evidence, followed by the activation of the ignition system circuit breaker, which resulted in a total loss of engine power.NTSB CEN19LA111Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Newton, KSThe loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.NTSB ERA19LA136Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95B55 · Clewiston, FLThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to perform the appropriate emergency checklists following the loss of engine power.NTSB WPR19LA101Accident · Serious injuriesClass 3 · LimitedFinal reportDennis l Zumbalt SKY Bolt · Deming, NMThe pilot’s failure to properly position the fuel selector before takeoff, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna L19 · Milton, LAA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA181Accident · Minor injuriesData collectionFinal reportAir Creation Tanarg · Kailua-Kona, HIThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR19LA097Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Newberg, ORThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ANC19LA015Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Talkeetna, AKA loss of pitch control for an undetermined reason, which resulted in a collision with terrain during an emergency landing.NTSB GAA19CA173Accident · Minor injuriesData collectionFinal reportPereira Osprey · Independence, IAThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA19LA126Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Ponte Vedra Beach, FLA total loss of engine power due to the introduction of air into fuel lines and an interruption of fuel flow to the engine.NTSB CEN19LA098Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32R · Waterloo, ILThe loss of engine power due to a connecting rod failure for reasons that could not be determined due to secondary mechanical damage, which resulted in a subsequent forced landing.NTSB GAA19CA166Accident · Minor injuriesData collectionFinal reportCessna 177RG · Land O' Lakes, WIThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB WPR19FA093Accident · 5 fatalClass 2 · FieldFinal reportPiper PA23 · Pahokee, FLThe pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19FA091Accident · 1 fatalClass 2 · FieldFinal reportBell UH1B · Forks, WAA total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…NTSB GAA19CA160Accident · No injuriesData collectionFinal reportPiper PA18 · Rushville, NEThe partial loss of engine power due to the accumulation of carburetor ice, which resulted in a forced landing on rough terrain.NTSB WPR19LA092Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Melba, IDThe total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.NTSB ERA19TA111Accident · No injuriesFinal reportPiper PA32 · West Palm Beach (Atlantic Ocean)A total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a ditched landing in the ocean.NTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.NTSB ERA19TA098Accident · Minor injuriesClass 3Final reportCessna 172 · Lignum, VAA total loss of engine power for undetermined reasons.NTSB GAA19CA133Accident · No injuriesData collectionFinal reportDenney Kitfox IV Speedster · Page, AZThe pilot's failure to maintain lateral control during the landing flare, which resulted in the left wing striking a tree.NTSB ERA19LA097Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLThe pilot's failure to use carburetor heat while operating the airplane in weather conditions and at engine power settings conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing and the subsequent forced…NTSB WPR19LA076Accident · Serious injuriesClass 3 · LimitedFinal reportWhittman 8-W Modified · Prospect, ORThe non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.NTSB CEN19TA073Accident · Serious injuriesFinal reportBeech A36 · Fort Worth, TXThe pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.NTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN19LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aguilares, TXThe loss of engine power due to fuel starvation.NTSB WPR19LA070Accident · No injuriesClass 3 · LimitedFinal reportHill Group CCX-2000 · Roll, AZThe loss of engine power due to a fatigue failure of the crankshaft for reasons that could not be determined based on the available information.NTSB CEN19LA060Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Keshena, WIA total loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.NTSB WPR19CA069Accident · No injuriesData collectionFinal reportChampion 7GCBC · Townsend, MTThe pilot's failure to maintain airplane control during a precautionary landing on an uneven, soft surface.NTSB WPR19LA063Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA22 · Kingman, AZThe student pilot's failure to secure the fuel caps, which led to the fuel being siphoned overboard, fuel exhaustion, and the total loss of engine power.NTSB CEN19LA053Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Salem, SDThe incapacitating effects of an acute myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB CEN19LA065Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Uvalde, TXThe slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.NTSB CEN19LA059Accident · No injuriesLimited investigationFinal reportCessna T210 · Flint, MIThe failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.NTSB ERA19LA085Accident · No injuriesLimited investigationFinal reportPiper PA24 · Wilkes-Barre, PAThe pilot/mechanic's improper installation and securing of the mixture control cable, which led to a simultaneous loss of total engine power and failure of the nose landing gear to fully extend when the cable caught on the nose landing gear assembly.NTSB ERA19LA081Accident · No injuriesLimited investigationFinal reportCessna LC41 · Apopka, FLA partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.NTSB WPR19CA052Accident · No injuriesData collectionFinal reportRobinson R22 · Hayward, CAAn in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.NTSB ERA19LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLA total loss of engine power due to the fatigue fracture of the No. 2 exhaust rocker arm stud.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB ERA19LA074Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · McCormick, SCA partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.NTSB ERA19LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Bell Glade, FLA partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.NTSB ERA19LA065Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Piper Sport · Punta Gorda, FLA total loss of engine power due to an interruption of fuel flow.NTSB ERA19LA063Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Moscow, PAA total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…NTSB WPR19LA035Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172P · Santa RitaA total loss of engine power for undetermined reasons.NTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.