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 CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.Mar 30, 2010 · N71229 · Substantial damageNTSB ERA10CA194Accident · Serious injuriesData collectionFinal reportPiper PA-28-180 · Palermo, NYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Mar 28, 2010 · N3442R · Substantial damageNTSB WPR10CA181Accident · No injuriesData collectionFinal reportMorrison Joseph Q2 · Frazier Park, CAA partial loss of engine power likely due to the failure of the oil pump.Mar 26, 2010 · N142BP · Substantial damageNTSB ERA10LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Moore, SCThe certificated mechanic's improper installation of a helicoil, which resulted in the separation of a sparkplug and the helicoil and led to a partial loss of engine power.Mar 24, 2010 · N93441 · Substantial damageNTSB ERA10LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Alfred, FLA loss of engine power during the landing approach for undetermined reasons.Mar 22, 2010 · N6589G · Substantial damageNTSB CEN10LA171Accident · No injuriesLimited investigationFinal reportLoehr Thomas H Zenith Stol CH701 · Eldon, MOA loss of engine thrust during takeoff due to the failure of the engine-to-propeller drive belts as a result of improper belt tension. Contributing to the accident was the non-certificated pilot's improper preflight inspection.Mar 22, 2010 · N144AC · Substantial damageNTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.Mar 20, 2010 · N61601 · DestroyedNTSB ERA10LA179Accident · No injuriesLimited investigationFinal reportFerguson William C FX4-2 · Cartersville, GAThe failure of the engine-driven oil pump drive coupling resulting in a loss lubrication and subsequent loss of engine power.Mar 19, 2010 · N8508H · Substantial damageNTSB WPR10LA168Accident · No injuriesLimited investigationFinal reportCessna 150F · Tillamook, ORThe partial loss of engine power during climb to cruise due to carburetor icing and the pilot's delay in using carburetor heat.Mar 17, 2010 · N7854F · Substantial damageNTSB WPR10LA166Accident · Serious injuriesLimited investigationFinal reportKjonaas Varieze · Casa Grande, AZA loss of engine power during cruise flight due to fuel exhaustion.Mar 17, 2010 · N50894 · Substantial damageNTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.Mar 17, 2010 · N1KU · Substantial damageNTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.Mar 15, 2010 · N9JE · Minor damageNTSB ERA10CA176Accident · No injuriesData collectionFinal reportRolladen-Schneider LS-4 · Jasper, TNThe inadequate in-flight planning by the glider pilot to intentionally cross a ridge at low altitude, resulting in the in-flight collision with trees.Mar 15, 2010 · N465CB · Substantial damageNTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.Mar 14, 2010 · N4974F · Substantial damageNTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.Mar 13, 2010 · N5392E · Substantial damageNTSB ANC10LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Ophir, AKThe total loss of engine power for an undetermined reason.Mar 10, 2010 · N70039 · Substantial damageNTSB WPR10RA197Accident · Serious injuriesForeign investigationEagle 150B · Kota Bahru, MalaysiaOn March 9, 2010, about 1630 local time, an Eagle 150B, Malaysia registration 9M-BEV, crashed near Kota Bahru, Kelantan, Malaysia, subsequent to an in-flight propeller separation. The two occupants, a flight instructor and student pilot, sustained serious…Mar 9, 2010 · 9M-BEV · Substantial damageNTSB CEN10CA146Accident · No injuriesData collectionFinal reportByler JDT MINI-MAX 1100R · New Paris, INA total loss of engine power in flight due to carburetor icing. Contributing to the accident was the soft field where the airplane nosed over.Mar 8, 2010 · N184PT · Substantial damageNTSB WPR10LA154Accident · No injuriesLimited investigationFinal reportSutton Avid Hauler · Rigby, IDA loss of engine power during takeoff for undetermined reasons.Mar 7, 2010 · N22EJ · Substantial damageNTSB ANC10LA020Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKA total loss of engine power in flight for undetermined reasons.Mar 6, 2010 · N26TC · Substantial damageNTSB CEN10LA140Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Slaton, TXThe loss of engine power due to the insufficient clamping force between the two crankcase halves and each cylinder to the crankcase.Mar 5, 2010 · N2036Y · Substantial damageNTSB CEN10CA138Accident · Serious injuriesData collectionFinal reportEnstrom 280FX · Goshen, INThe inadequate preflight inspection by both pilots, resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the disconnected fuel tank sending unit.Mar 4, 2010 · N327TB · Substantial damageNTSB ERA10LA159Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Arcadia, FLThe total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.Mar 3, 2010 · N4797K · Substantial damageNTSB CEN10LA131Accident · No injuriesLimited investigationFinal reportLacour Long-EZE SR7-1 · Falfurrias, TXA total loss of engine power due to a failure of the crankshaft behind the No. 3 connecting rod journal for undetermined reasons.Mar 1, 2010 · N97EZ · Substantial damageNTSB WPR10LA149Accident · Minor injuriesLimited investigationFinal reportSchafer Starduster SA-300 · North Bend, ORThe complete loss of engine power during cruise for undetermined reasons.Feb 28, 2010 · N105NL · Substantial damageNTSB WPR10LA125Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Byron, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Feb 23, 2010 · N8494K · Substantial damageNTSB WPR10CA144Accident · No injuriesData collectionFinal reportCessna 172 · Sparks, NVA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the correct fuel selector position.Feb 22, 2010 · N7499A · Substantial damageNTSB ERA10LA151Accident · Serious injuriesLimited investigationFinal reportCotter Stits Playmate · Williston, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's fuel mismanagement.Feb 21, 2010 · N816 · Substantial damageNTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.Feb 18, 2010 · N731DS · Substantial damageNTSB WPR10LA138Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Parlier, CAThe pilot inadvertently entered a low-G condition during cruise flight, which resulted in a momentary loss of control of the helicopter and mast bumping.Feb 17, 2010 · N313DA · Substantial damageNTSB CEN10LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Genoa City, WIA total loss of engine power due to the failure of the bolts that held in place the connecting rods to the engine's No. 3 and No. 4 cylinders as a result of the engine overhaul facility's improper installation of the bolts during a recent overhaul.Feb 14, 2010 · N24CV · Substantial damageNTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.Feb 8, 2010 · N130SP · Substantial damageNTSB WPR10LA130Accident · Minor injuriesLimited investigationFinal reportNanchang China CJ-6A · Mesa, AZSeparation of the cylinder from the engine during cruise flight due to fatigue in the studs attaching it to the engine casing.Feb 7, 2010 · N6263D · Substantial damageNTSB WPR10CA129Accident · No injuriesData collectionFinal reportMaule M-5-235C · Kelton, UTThe non-instrument-rated pilot's decision to take off and fly into marginal weather conditions.Feb 6, 2010 · N9227E · Substantial damageNTSB ERA10LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Augustine, FLA loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.Feb 1, 2010 · N3995J · Substantial damageNTSB WPR10LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Pahrump, NVFuel starvation as a result of the improper installation of the carburetor float valve by unknown personnel.Jan 30, 2010 · N8959B · Substantial damageNTSB WPR10LA122Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAA partial loss of engine power during takeoff due to a bird's nest being sucked into the induction air ducting.Jan 30, 2010 · N6799K · Substantial damageNTSB CEN10FA162Accident · No injuriesField investigationFinal reportMaule M-6-235 · Bennett, COThe pilot’s failure to maintain clearance from a utility line while maneuvering.Jan 30, 2010 · N7613X · Substantial damageNTSB ERA11WA269Incident · No injuriesForeign investigationEmbraer EMB-202 · Guarau, BrazilOn January 28, 2010, about 1030 coordinated universal time, an Embraer EMB-202, Brazilian registration PT-UPW, had a reported loss of power during cruise and landed in a soybean field near Guarau, Santa Catarina, Brazil. The pilot was not injured And the…Jan 28, 2010 · PT-UPW · No damageNTSB WPR10LA119Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · La Quinta, CAA loss of engine power during cruise flight due to water contamination in the fuel.Jan 25, 2010 · N243SC · Substantial damageNTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.Jan 23, 2010 · N8948T · Substantial damageNTSB ERA10WA340Accident · Minor injuriesForeign investigationRobinson R44 · San Felipe, ChileOn January 21, 2010, at 2210 universal coordinated time, a Robinson R44 helicopter, Chilean registration CC-PSZ, experienced a loss of engine power while in cruise flight, and was substantially damaged during a subsequent forced landing, in San Felipe, Chile.…Jan 21, 2010 · CC-PSZ · Substantial damageNTSB WPR10GA102Accident · Serious injuriesFinal reportHughes 369D · Kooskia, IDA complete loss of engine power due to the failure of the No. 2 bearing, which was precipitated by electrical arcing that occurred at an unknown time prior to the accident flight.Jan 8, 2010 · N500LW · Substantial damageNTSB CEN10CA087Accident · No injuriesData collectionFinal reportMaule M-4-220C · Pearsall, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.Jan 2, 2010 · N2028U · Substantial damageNTSB ERA10LA104Accident · No injuriesLimited investigationFinal reportCessna 150G · Doylestown, PAA partial loss of engine power due to carburetor icing.Jan 1, 2010 · N4026J · Substantial damage