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 ERA10LA487Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Dublin, GAThe pilot's failure to properly secure the oil drain plug after changing the engine oil, which resulted in oil starvation and an engine failure during cruise flight.Sep 19, 2010 · N2448T · Substantial damageNTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.Sep 19, 2010 · N799SQ · Substantial damageNTSB ERA10LA494Accident · No injuriesLimited investigationFinal reportCessna 172D · Palm Beach, FLThe pilot's failure to use carburetor heat which led to a loss of engine power due to carburetor icing.Sep 18, 2010 · N2483Y · Substantial damageNTSB ERA10LA485Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Rainelle, WVThe improper rigging of the fuel selector by maintenance personnel, which resulted in a total loss of engine power.Sep 18, 2010 · N86BR · Substantial damageNTSB CEN10LA571Accident · Serious injuriesLimited investigationFinal reportCa Tecnam P2004 Bravo · Mason, MIA total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.Sep 17, 2010 · N508LM · Substantial damageNTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.Sep 16, 2010 · N2153S · Substantial damageNTSB ERA10LA475Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fayetteville, WVA loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel.Sep 10, 2010 · N7922E · Substantial damageNTSB ERA10LA474Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Doerun, GAA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site and his excess speed during the landing.Sep 10, 2010 · N2312Y · Substantial damageNTSB ERA10CA472Accident · Minor injuriesData collectionFinal reportCessna 180 · Huron, NYThe pilot's inadequate preflight planning and preparation, which resulted in a total loss of engine power due to fuel exhaustion.Sep 9, 2010 · N180LE · Substantial damageNTSB CEN10CA532Accident · Minor injuriesData collectionFinal reportRobertson Velocity · Wooster, OHA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Sep 9, 2010 · N112TH · Substantial damageNTSB CEN10FA521Accident · No injuriesField investigationFinal reportCessna P210N · Caledonia, MIA loss of engine power as a result of a fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the accident was a mechanic's use of incorrect hardware.Sep 6, 2010 · N4632A · Substantial damageNTSB CEN10CA536Accident · No injuriesData collectionFinal reportCessna A188B · Hondo, TXThe pilot’s delayed action to arrest the airplane’s descent, which resulted in a collision with terrain.Sep 6, 2010 · N731PQ · Substantial damageNTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.Sep 5, 2010 · N4664 · Substantial damageNTSB CEN10CA525Accident · Minor injuriesData collectionFinal reportWeber Acro Sport II · Plum City, WIThe pilot’s improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Sep 5, 2010 · N819WW · Substantial damageNTSB ERA10LA466Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Virginia Beach, VAA total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.Sep 4, 2010 · N812KT · Substantial damageNTSB ERA10CA462Accident · Serious injuriesData collectionFinal reportHead Balloons AX9 118 · Hanover, NHThe balloon's encounter with an updraft, resulting in an immediate landing and an intentional collision with a tree.Sep 1, 2010 · N2267U · Minor damageNTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.Sep 1, 2010 · N3446B · Substantial damageNTSB ERA10LA458Accident · No injuriesLimited investigationFinal reportBird CK · Eagles Mere, PAThe loss of engine power due to fuel starvation as a result of degradation of the fuel tank coating which blocked the fuel supply.Aug 31, 2010 · N765N · Substantial damageNTSB ERA10LA457Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Jacksonville, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of power in both engines during climb due to fuel contamination.Aug 31, 2010 · N175SP · Substantial damageNTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.Aug 31, 2010 · N20HY · Substantial damageNTSB ERA10LA454Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Acworth, GAThe pilots improper in-flight fuel management resulting in a total loss of engine power during a descent due to fuel starvation.Aug 29, 2010 · N451TS · Substantial damageNTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.Aug 29, 2010 · N2493N · DestroyedNTSB WPR10LA432Accident · Minor injuriesLimited investigationFinal reportStinson JR. S · Lake Stevens, WAA total loss of engine power during cruise flight, which resulted from a magneto switch failure.Aug 28, 2010 · N12164 · Substantial damageNTSB WPR10CA434Accident · Minor injuriesData collectionFinal reportPiper PA-15 · Duvall, WAAn in-flight collision with a bird while maneuvering.Aug 28, 2010 · N4579H · Substantial damageNTSB ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.Aug 28, 2010 · N85929 · Substantial damageNTSB CEN10CA507Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Socorro, NMA loss of lift that resulted in an off-airport landing.Aug 28, 2010 · N361BA · Substantial damageNTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.Aug 27, 2010 · N8919R · Substantial damageNTSB ANC10CA079Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKA faulty fuel quantity indication in-flight, which precipitated a precautionary off-airport landing, and collision with a road sign.Aug 26, 2010 · N5114H · Substantial damageNTSB WPR10FA423Accident · Minor injuriesField investigationFinal reportCessna 182 · Ojai, CAA loss 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.Aug 24, 2010 · N3850D · Substantial damageNTSB CEN10LA524Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Greeley, COA loss of engine power for undetermined reasons.Aug 24, 2010 · N4167A · Substantial damageNTSB CEN10LA498Accident · Minor injuriesLimited investigationFinal reportFreeman Super Koala · Traverse City, MIA loss of engine power due to the improper torquing of the number one cylinder's spark plug as a result of inadequate maintenance.Aug 24, 2010 · N220FF · Substantial damageNTSB CEN10CA500Accident · Minor injuriesData collectionFinal reportCessna 150K · Gaylord, MIA loss of engine power for undetermined reasons.Aug 24, 2010 · N6032G · Substantial damageNTSB WPR10LA420Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · San Diego, CAThe pilot's failure to utilize carburetor heat during initial climb, which resulted in a loss of engine power due to carburetor icing.Aug 23, 2010 · N7186Z · Substantial damageNTSB WPR10LA424Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Lakeview, ORA partial loss of engine power during the initial climb due to a stuck exhaust valve.Aug 22, 2010 · N26118 · Substantial damageNTSB WPR10LA419Accident · No injuriesLimited investigationFinal reportHummel / Finberg Ultra Cruiser · Canby, ORThe loss of engine power due to low cylinder compression.Aug 21, 2010 · N524DF · Substantial damageNTSB ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.Aug 21, 2010 · N209RC · Substantial damageNTSB WPR10LA412Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Manson, WAA loss of engine power due to fuel exhaustion, and the pilot’s failure to ensure that a sufficient quantity of fuel was on board to complete the flight.Aug 19, 2010 · N30559 · Substantial damageNTSB CEN10LA494Accident · No injuriesLimited investigationFinal reportCessna 310F · LaGrange, INThe pilot did not maintain altitude due to his distracted attention to a vibration of unknown origin.Aug 19, 2010 · N6762X · Substantial damageNTSB CEN10LA483Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Idabel, OKA loss of engine power for undetermined reasons.Aug 16, 2010 · N513CM · Substantial damageNTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.Aug 15, 2010 · N792Y · Substantial damageNTSB CEN10LA478Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Justin, TXA loss of engine power due to fuel starvation as a result of the pilot's delay in transferring fuel from the gravity feed wing tanks to the main tank.Aug 14, 2010 · N85065 · Substantial damageNTSB WPR10CA401Accident · Minor injuriesData collectionFinal reportCessna 180D · Hillsboro, ORA loss of engine power due to fuel starvation resulting from unporting when the pilot entered into a slip during the turn to the final approach leg.Aug 13, 2010 · N6475X · Substantial damageNTSB ERA10CA417Accident · No injuriesData collectionFinal reportPiper PA-25-260 · St. Petersburg, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 12, 2010 · N254AB · Substantial damageNTSB WPR10LA396Accident · No injuriesLimited investigationFinal reportGrumman G164 · Tracy, CAA total loss of engine power while maneuvering due to an internal catastrophic failure to the master rod and piston connecting rod links.Aug 11, 2010 · N6781K · Substantial damageNTSB ERA10LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Eastman, GABoth pilots’ failure to use emergency checklist procedures for restarting the engine after the loss of engine power due to fuel starvation.Aug 10, 2010 · N730FT · Substantial damageNTSB ERA10FA409Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Washington, GAThe manufacturer's inadequate quality control and improper manufacture of the fuel servo diaphragm assembly, which resulted in fatigue cracking of the hub stud and subsequent loss of engine power due to fuel starvation.Aug 10, 2010 · N220ST · Substantial damageNTSB WPR10FA387Accident · Minor injuriesField investigationFinal reportPZL Mielec M18 · Meridian, CALong-term deterioration of multiple engine fuel vaporizers that led to material failure of multiple turbine blades, which resulted in a complete loss of engine power. Contributing to the accident were the exceedance of specified engine inspection intervals…Aug 6, 2010 · N70461 · Substantial damageNTSB WPR10CA389Accident · No injuriesData collectionFinal reportLet L 33 Solo · Adelanto, CAThe pilot’s inability to make it to the airport as a result of his inadequate planning for the gusting headwinds.Aug 6, 2010 · N315BA · Substantial damageNTSB WPR10FA385Accident · Minor injuriesField investigationFinal reportPiper PA-24-260C · Ridgecrest, CAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management during cruise flight.Aug 5, 2010 · N9365P · Substantial damageNTSB ERA10LA400Accident · No injuriesLimited investigationFinal reportDayton JD-2 · Hollywood, MDThe pilot's improper installation of the propeller hub to the engine crankshaft, which resulted in a loss of engine thrust.Aug 5, 2010 · N43015 · Substantial damage