NTSB investigations, 2010, AZ

10 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2010, AZ per year, 2008–2026: 107 cases
20087
200912
201010
20118
20125
20136
201410
20155
20167
20176
20183
20196
20203
20211
20226
20233
20245
20254

Latest cases

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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    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 WPR11LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Wittmann, AZThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 1, 2010 · N4122F · 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 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 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 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 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 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 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 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 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 damage