NTSB investigations, VA

69 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 c.\"eventStateOrRegion\" = 'VA' 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 ERA12LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Flat Rock, VAThe partial loss of engine power due to the failure of the exhaust valve spring seat for reasons that could not be determined.Feb 17, 2012 · N4737D · Substantial damageNTSB ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.Nov 25, 2011 · N816BA · Substantial damageNTSB ERA12CA059Accident · Minor injuriesData collectionFinal reportBeech F33A · Chesterfield, VAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.Nov 2, 2011 · N833 · Substantial damageNTSB ERA12LA033Accident · No injuriesLimited investigationFinal reportCessna R172K · Williamsburg, VAA total 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.Oct 17, 2011 · N758GY · Substantial damageNTSB ERA11CA465Accident · No injuriesData collectionFinal reportLet L 33 Solo · Wakefield, VAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing.Aug 17, 2011 · N388BA · Substantial damageNTSB ERA11CA423Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Quinton, VAThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 26, 2011 · N81917 · Substantial damageNTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.May 15, 2011 · N929RL · 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 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 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 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 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 ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.Sep 13, 2009 · N734TV · Substantial damageNTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.Aug 26, 2009 · N186CF · Substantial damageNTSB ERA09LA441Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Suffolk, VAA loss of engine power due to fuel exhaustion as a result of the pilot’s failure to accurately calculate the fuel required for the flight. Contributing to the accident was a malfunction of the fuel quantity indicators.Aug 3, 2009 · N3549N · Substantial damageNTSB ERA09LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Lawrenceville, VAA loss of engine power due to carburetor icing.Jun 13, 2009 · N22075 · Substantial damageNTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.Mar 22, 2009 · N2360M · Substantial damageNTSB NYC08FA292Accident · No injuriesField investigationFinal reportSteven A. Jones Lancair IV P · Stafford, VAThe pilot's decision to install voltage regulators in the engine compartment where they were susceptible to water intrusion, which resulted in a malfunction of the standby electrical system's voltage regulator and a subsequent in-flight fire.Aug 11, 2008 · N731SJ · Substantial damageNTSB NYC08CA275Accident · Serious injuriesData collectionFinal reportI.C.A.-Brasov IS-26B2 · Fincastle, VAThe pilot's geographic disorientation, which resulted in an off-airport landing. Contributing to the accident was the pilot's selection of an inadequate landing site.Aug 10, 2008 · N4281B · Substantial damage