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 ERA10LA316Accident · Minor injuriesLimited investigationFinal reportMcculloch Jerry RV-4 · Pageland, SCMaintenance personnel’s improper installation and inspection of the crankshaft idler gear, which resulted in a loss of engine power.Jun 17, 2010 · N418GM · Substantial damageNTSB CEN10CA317Accident · No injuriesData collectionFinal reportBell 47G · Plymouth, MIThe pilot's failure to use carburetor heat, which led to carburetor icing and a loss of engine power following takeoff.Jun 13, 2010 · N47WK · Substantial damageNTSB WPR10CA288Accident · No injuriesData collectionFinal reportBurkhart Grob G103C Twin III Acro · Minden, NVThe pilot's encounter with an area of degraded lift during cruise flight, resulting in a forced off-airport landing.Jun 11, 2010 · N41KP · Substantial damageNTSB WPR10LA284Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Ontario, CAA loss of engine power due to the in-flight separation of the 1-3-5 cylinder induction tube elbow, which was caused by the improper installation of the induction tube elbow by maintenance personnel.Jun 10, 2010 · N121HJ · Substantial damageNTSB CEN10CA313Accident · No injuriesData collectionFinal reportLuscombe 8F · Shell Knob, MOA total loss of engine power for undetermined reasons.Jun 10, 2010 · N9932C · Substantial damageNTSB ERA10LA307Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe total loss of engine power due to inadequate torgue on the crankcase bolts. Contributing to the accident was the inadequate inspection performed 19.5 hours prior to the accident.Jun 9, 2010 · N2263S · Substantial damageNTSB WPR10CA283Accident · No injuriesData collectionFinal reportBell 47G-4A · Shaw Island, WAThe passenger's inadvertent movement of the mixture control during climb, resulting in a loss of engine power.Jun 8, 2010 · N7069J · Substantial damageNTSB ERA10LA306Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lucedale, MSThe partial separation of the No. 3 cylinder due to improper torquing of the cylinder hold-down bolts by maintenance personnel during installation of the cylinder.Jun 8, 2010 · N5118L · Substantial damageNTSB ERA10LA301Accident · No injuriesLimited investigationFinal reportHood John Sidney Tango · New Port Richey, FLThe improper inspection of the airplane ignition system during the last condition inspection by a mechanic, resulting in an ignition cable disconnecting and a partial loss of engine power.Jun 7, 2010 · N76HT · Substantial damageNTSB CEN10LA306Accident · No injuriesLimited investigationFinal reportCessna 177RG · Marietta, OHThe total loss of engine power due to the fatigue failure of the No. 2 cylinder attachment fasteners as a result of improper engine overhaul practices.Jun 7, 2010 · N2016Q · Substantial damageNTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.Jun 7, 2010 · N9620S · Substantial damageNTSB WPR10LA280Accident · No injuriesLimited investigationFinal reportBeech F33 · Marana, AZThe loss of engine power while maneuvering to land for undetermined reasons.Jun 5, 2010 · N1565A · Substantial damageNTSB ERA10LA298Accident · No injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLA partial loss of power during takeoff for undetermined reasons.Jun 5, 2010 · N2990V · Substantial damageNTSB ERA10LA297Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Rockohoma, NYThe pilot's inadequate preflight inspection which resulted in a total loss of engine power during the initial climb due to fuel contamination.Jun 5, 2010 · N1958W · Substantial damageNTSB CEN10CA305Accident · No injuriesData collectionFinal reportCessna 337 · Custer, SDA partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.Jun 5, 2010 · N2267X · Substantial damageNTSB WPR10LA302Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Richfield, UTThe pilot’s decision to operate the unairworthy airplane with suspected performance deficiencies in a high density altitude and the subsequent partial loss of engine power due to low compression.Jun 4, 2010 · N3922K · Substantial damageNTSB WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.Jun 1, 2010 · N8815U · Substantial damageNTSB ERA10LA294Accident · Minor injuriesLimited investigationFinal reportSwanson RV-9A · Ashland, VAThe pilot's failure to obtain the proper touchdown point during a forced landing in gusting wind. Contributing to the accident was a total loss of engine power, likely due to carburetor ice.Jun 1, 2010 · N858JK · Substantial damageNTSB ERA10LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Dania Beach, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jun 1, 2010 · N1435F · Substantial damageNTSB CEN10CA280Accident · No injuriesData collectionFinal reportHughes 269A · Cannon Falls, MNThe pilot's failure to maintain rotor speed during the autorotation, which resulted in an excessive sink rate and a hard landing.Jun 1, 2010 · N8897F · Substantial damageNTSB CEN10WA331Accident · No injuriesForeign investigationCirrus Design SR20 · Sirdal, NorwayOn May 28, 2010, at 1708 coordinated universal time (UTC), a Cirrus Design Corporation model SR20 airplane, s/n 1888, Norwegian registration LN-BCD, was substantially damaged when it impacted mountainous terrain near Sirdal, Norway. The flight had encountered…May 28, 2010 · LN-BCD · Substantial damageNTSB ERA10LA284Accident · Minor injuriesLimited investigationFinal reportCessna 337G · High Springs, FLThe pilot's failure to follow the published engine-out procedures after a total loss of power in the rear engine. Contributing to the accident was the inadequate maintenance and inspection of the engine by the pilot and maintenance personnel.May 27, 2010 · N72268 · Substantial damageNTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…May 26, 2010 · N73SJ · Substantial damageNTSB WPR10LA251Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Benson, AZA loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.May 21, 2010 · N6630X · Substantial damageNTSB WPR10LA247Accident · No injuriesLimited investigationFinal reportAyres S2R · Glenn, CALoss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.May 18, 2010 · N29254 · Substantial damageNTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.May 9, 2010 · N144TJ · Substantial damageNTSB CEN10LA242Accident · No injuriesLimited investigationFinal reportJorritsma Jerrold S Berkut · Loveland, COA loss of engine power due to a malfunction of the fuel controller resulting in a compressor stall.May 9, 2010 · N3255U · Substantial damageNTSB WPR10LA232Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Mendon, UTA loss of engine power due to a failure of the magnetos as a result of inadequate maintenance.May 7, 2010 · N393LE · Substantial damageNTSB CEN10CA246Accident · No injuriesData collectionFinal reportCarlesimo Glasair III T · Lynwood, ILA loss of engine power due to fuel starvation as a result of the pilot's failure to follow the pre-landing checklist and verifying the position of the fuel selector.May 7, 2010 · N713MJ · Substantial damageNTSB CEN10LA241Accident · Minor injuriesLimited investigationFinal reportHager Clinton Ray Vans RV-8 · Prague, OKThe in-flight separation of a propeller blade for undetermined reasons.May 6, 2010 · N127TT · Substantial damageNTSB ERA10LA248Accident · Minor injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-C · LaGrange, GAA loss of engine power due to the pilot's inadequate preflight inspection and his failure to ensure that the fuel tank shut-off valve was open resulting in fuel starvation.Apr 28, 2010 · N87172 · Substantial damageNTSB WPR10CA215Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Marana, AZThe pilot's inability to find thermal lift. Contributing to the accident was the failure of a computer that provided glide information and vertical speed instrumentation as a result of an improperly routed electrical cable that caused a short in the…Apr 26, 2010 · N500JN · Substantial damageNTSB WPR10LA214Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Madera, CAA loss of engine power for undetermined reasons.Apr 23, 2010 · N4450 · Substantial damageNTSB WPR10LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Tooele, UTThe complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…Apr 21, 2010 · N331GP · Substantial damageNTSB CEN10LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Alpine, TXA total loss of engine power for undetermined reasons.Apr 21, 2010 · N9197F · Substantial damageNTSB CEN10CA211Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · White Bear Lake, MNA total loss of engine power during takeoff due to fuel contamination as a result of the pilot's inadequate preflight inspection.Apr 20, 2010 · N87792 · Substantial damageNTSB WPR10CA224Accident · No injuriesData collectionFinal reportEvolution Trikes Revo · Eleele, HIA loss of engine power as a result of fuel exhaustion due to the pilot's improper decision to continue the flight after the low fuel warning. Contributing to the accident was the typographical error in the flight manual concerning the unusable fuel quantity.Apr 19, 2010 · N98EV · Substantial damageNTSB WPR10LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182 · El Cajon, CAThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Apr 17, 2010 · N5318B · Substantial damageNTSB ERA10LA229Accident · No injuriesLimited investigationFinal reportDalin Ronald K T-51 Mustang · Lakeland, FLThe builder’s use of inadequate material for the exhaust manifold adapters resulting in heat damage and chafing of the crankshaft synchronizer and timing wires that rendered an inoperative ignition system and loss of engine power.Apr 14, 2010 · N551RD · Substantial damageNTSB ERA10LA222Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Arecibo, PRA loss of engine power in one engine due to fuel starvation as a result of the pilot's improper fuel management, resulting in a forced landing in a field.Apr 11, 2010 · N9646Y · Substantial damageNTSB WPR10LA202Accident · No injuriesLimited investigationFinal reportCostruzioni AeronauticheTecnam P2002 Sierra · Tooele, UTA total loss of engine power for undetermined reasons.Apr 10, 2010 · N797TS · Substantial damageNTSB ERA10TA215Accident · No injuriesFinal reportCessna 404 · Ponce, PRA loss of power to the right engine for undetermined reasons.Apr 7, 2010 · N6035 · Substantial damageNTSB ERA10CA220Accident · Minor injuriesData collectionFinal reportCessna 150G · Cooperstown, NYA partial loss of engine power during a simulated engine-out demonstration due to carburetor icing.Apr 7, 2010 · N4760X · Substantial damageNTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.Apr 4, 2010 · N3599P · Substantial damageNTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.Apr 3, 2010 · N5528T · Substantial damageNTSB ERA10LA203Accident · 1 fatalLimited investigationFinal reportLopez Phillip Jabiru J250 · Middletown, DEThe pilot's failure to apply carburetor heat, which resulted in the formation of carburetor icing and a total loss of engine power.Apr 2, 2010 · N464PP · Substantial damageNTSB CEN10CA185Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malden, MOThe pilot's failure to maintain clearance from a tree during an aerial application flight.Apr 2, 2010 · N3653T · Substantial damageNTSB CEN10FA180Accident · 2 fatalField investigationFinal reportBeech B36TC · Dayton, OHThe complete loss of engine power due to failure of the No. 1 main bearing, and the secondary failure of a crankcase through-bolt and the fuel pump drive coupling. Contributing to the accident was the pilot's decision to attempt a return to the airport for a…Apr 1, 2010 · N4BA · DestroyedNTSB CEN10CA178Accident · No injuriesData collectionFinal reportCessna 172N · Ankeny, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight fuel monitoring.Mar 31, 2010 · N883AV · Substantial damageNTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.Mar 30, 2010 · N52790 · Substantial damage