NTSB investigations, 2010

245 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\") = 2010
    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 ERA10LA401Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Donalsonville, GAA total loss of engine power due to a failure of the compressor turbine blades for undetermined reasons.Aug 4, 2010 · N4004D · Substantial damageNTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.Aug 2, 2010 · N444YP · Substantial damageNTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.Aug 2, 2010 · N389HW · Substantial damageNTSB WPR10LA376Accident · No injuriesLimited investigationFinal reportCessna 177 · Rawlins, WYThe pilot's inadequate preflight planning, failure to properly use the takeoff checklist, and failure to lean the fuel mixture, which resulted in the airplane’s inability to attain sufficient airspeed due to the rich fuel mixture.Jul 31, 2010 · N35296 · Substantial damageNTSB ERA10CA392Accident · No injuriesData collectionFinal reportCessna 172N · Elk Creek, VAThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in an off-airport landing.Jul 31, 2010 · N172FL · Substantial damageNTSB CEN10LA455Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · Kountze, TXA loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.Jul 31, 2010 · N305SD · Substantial damageNTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.Jul 30, 2010 · N17965 · Substantial damageNTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.Jul 30, 2010 · N17MX · Substantial damageNTSB ERA10LA383Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Holly Hill, SCMaintenance personnel's improper inspection and cleaning of the fuel nozzle, which resulted in a total loss of engine power.Jul 29, 2010 · N104HH · Substantial damageNTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.Jul 29, 2010 · N2085J · Substantial damageNTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…Jul 28, 2010 · N509AM · Substantial damageNTSB CEN10LA440Accident · No injuriesLimited investigationFinal reportBeech F35 · Enid, OKA loss of engine power for undetermined reasons.Jul 27, 2010 · N3858B · Substantial damageNTSB CEN10IA438Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAThe loss of main rotor rpm during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies.Jul 26, 2010 · N317RL · Minor damageNTSB ERA10LA377Accident · No injuriesLimited investigationFinal reportCessna 172N · Waynesboro, VAThe pilot's failure to follow the short-field takeoff procedures published in the Pilot's Operating Handbook.Jul 24, 2010 · N3480E · Substantial damageNTSB ERA10LA373Accident · 2 fatalLimited investigationFinal reportNadig Paul K Nadig · Franklin, PAA partial loss of engine power due to the owner’s inadequate fuel system maintenance, which resulted in a collision with trees and subsequent impact with the ground.Jul 24, 2010 · N579PN · Substantial damageNTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.Jul 23, 2010 · N40TA · Substantial damageNTSB CEN10LA425Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar · Cleburne, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident were the critical fuel placards that were difficult to see due to the airplane's paint scheme.Jul 22, 2010 · N601AT · DestroyedNTSB CEN10LA408Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Minden, NEThe pilot's inadequate flare during an autorotation, which resulted in a hard landing and subsequent rollover.Jul 19, 2010 · N410JM · Substantial damageNTSB CEN10CA384Accident · Serious injuriesData collectionFinal reportAmerican AA-1 · Gallup, NMThe pilot's inadequate in-flight planning and failure to attain 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 the high density altitude.Jul 19, 2010 · N5660L · Substantial damageNTSB WPR10LA357Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Phoenix, AZA loss of engine power during descent due to fuel starvation that resulted from the pilot's mismanagement of the fuel system.Jul 18, 2010 · N9SH · Substantial damageNTSB WPR10LA356Accident · 1 fatalLimited investigationFinal reportParker RS-15 Sailplane · Marysvale, UTThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.Jul 17, 2010 · N15LQ · Substantial damageNTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…Jul 16, 2010 · PR-TNB · DestroyedNTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.Jul 15, 2010 · N802JB · Substantial damageNTSB ERA10LA361Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Melbourne, FLSeparation of the main rotor drive belts due to maintenance personnel’s failure to adequately inspect the upper drive sheave prior to installing the belts.Jul 15, 2010 · N74603 · Substantial damageNTSB CEN10LA416Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Krum, TXA total loss of engine power in flight due to carburetor icing.Jul 14, 2010 · N35645 · Substantial damageNTSB WPR10LA345Accident · No injuriesLimited investigationFinal reportCessna 177 · Chino, CAThe pilot’s inadequate fuel planning which resulted in a loss of engine power during cruise flight due to fuel exhaustion.Jul 11, 2010 · N3295T · Substantial damageNTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.Jul 10, 2010 · N3784A · Substantial damageNTSB WPR10LA343Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Whitehall, MTA loss of engine power for undetermined reasons.Jul 9, 2010 · N87349 · Substantial damageNTSB WPR10LA339Accident · Minor injuriesLimited investigationFinal reportDouglas A4L · Fallon, NVA loss of engine power during takeoff due to the failure of the engine's stator and turbine. Contributing to the accident was inadequate maintenance.Jul 8, 2010 · N132AT · Substantial damageNTSB WPR10CA311Accident · No injuriesData collectionFinal reportCessna 172F · Rancho Murieta, CAA total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jul 8, 2010 · N8793U · Substantial damageNTSB CEN10LA380Accident · Minor injuriesLimited investigationFinal reportChampion 8KCAB · Estes Park, COThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.Jul 8, 2010 · N56BC · Substantial damageNTSB WPR10CA332Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garfield, WAA loss of engine power due to fuel exhaustion.Jul 6, 2010 · N8878S · Substantial damageNTSB ERA10LA349Accident · No injuriesLimited investigationFinal reportBeech F33A · Mooresville, NCA loss of engine power for undetermined reasons.Jul 6, 2010 · N350NW · Substantial damageNTSB WPR10LA331Accident · No injuriesLimited investigationFinal reportCessna 210 · Coeur d'Alene, IDThe loss of engine power during cruise flight for undetermined reasons.Jul 5, 2010 · N8133G · Substantial damageNTSB CEN10LA368Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Pocahontas, ILThe pilot's failure to maintain a wings-level attitude prior to impacting high vegetation and terrain during the off-field landing.Jul 4, 2010 · N82BK · Substantial damageNTSB CEN10CA376Accident · No injuriesData collectionFinal reportWells Terry Hula Girl · Wellington, COA partial loss of engine power due to the inadequate design of the engine cowling.Jul 3, 2010 · N301TW · Substantial damageNTSB CEN10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Centerville, MOA loss of engine power due to carburetor icing as a result of the pilot not using carburetor heat.Jul 2, 2010 · N5798P · Substantial damageNTSB CEN10CA398Accident · No injuriesData collectionFinal reportBradshaw Quicksilver MX II · Newark, ILA total loss of engine power during cruise when the ignition switch vibrated into the "off" position, leading to the airplane's impact with a ditch during the off-field landing.Jul 1, 2010 · N4469N · Substantial damageNTSB ANC10LA056Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe total loss of engine power during cruise flight due to a fractured crankshaft.Jun 30, 2010 · N4596U · Substantial damageNTSB WPR10LA317Accident · Serious injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZThe in-flight separation of the exhaust clamps for an undetermined reason, which resulted in the exhaust system striking the wooden propeller.Jun 28, 2010 · N707BD · Substantial damageNTSB WPR10LA316Accident · No injuriesLimited investigationFinal reportMcGlashan T-51 Mustang · Columbia, CAA loss of engine power during approach due to thermal damage to the engine's electronic ignition module. Contributing to the accident was the builder’s placement of the ignition module near the engine’s exhaust.Jun 27, 2010 · N751RM · Substantial damageNTSB ERA10LA335Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Babylon, NYThe loss of engine power due to the failure of the oil filter gasket and the subsequent engine oil depletion.Jun 25, 2010 · N3973Y · Substantial damageNTSB CEN10LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Fremont, NEThe pilot’s loss of control for undetermined reasons.Jun 25, 2010 · N269JW · Substantial damageNTSB WPR10LA313Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-1 · Port Orchard, WAA loss of engine power during initial climb due to water contamination in the fuel.Jun 24, 2010 · N6540C · Substantial damageNTSB WPR10LA310Accident · Serious injuriesLimited investigationFinal reportRice KR-2 · Richfield, UTA loss of engine power during initial climb due to a carburetor malfunction.Jun 23, 2010 · N44729 · Substantial damageNTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…Jun 21, 2010 · N30266 · Substantial damageNTSB CEN10CA330Accident · No injuriesData collectionFinal reportTaylorcraft DCO-65 · Akron, OHThe loss of engine power for undetermined reasons.Jun 20, 2010 · N61720 · Substantial damageNTSB ERA10WA338Accident · 2 fatalForeign investigationBolkow BO105 · Buenos Aires, ArgentinaOn June 18, 2010, about 1118 universal Coordinated Time (UTC),an Bolkow BO-105, Argentina registration LV-WJX, operated by a private owner on a business flight, to photograph a automobile accident, collided with tall trees, overhead power lines, and struck…Jun 18, 2010 · LV-WJX · DestroyedNTSB ERA10LA325Accident · Minor injuriesLimited investigationFinal reportSchleicher ASH26 · Shelbyville, TNA complete loss of electrical and engine power over unsuitable terrain due to a cannon plug that became disconnected for undetermined reasons.Jun 18, 2010 · N26EL · Substantial damageNTSB ERA10LA317Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAA total loss of engine power during final approach due to fuel starvation as a result of the pilot’s delayed configuration of the airplane for landing.Jun 18, 2010 · N401TE · Substantial damage