NTSB investigations, VA
68 cases where the sequence of events included Loss of control in flight.
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\" = '240' 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.
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" = '240' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA12CA402Accident · No injuriesData collectionFinal reportAeronca 7AC · Blairs, VAThe pilot's failure to maintain directional control during a takeoff into sun glare.NTSB ERA12CA054Accident · Serious injuriesData collectionFinal reportAeros Trike · Amherst, VAThe student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.NTSB ERA11FA443Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Warrenton, VAThe pilot's inadequate airspeed and excessive bank angle while maneuvering for landing, which resulted in an aerodynamic stall.NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.NTSB ERA10CA477Accident · Minor injuriesData collectionFinal reportBeam-Walter RS-15 · Windsor, VAThe pilot's inadequate installation and preflight inspection of the right rudervator assembly, which resulted in a loss control during takeoff.NTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.NTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…NTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.NTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.NTSB ERA09LA370Accident · Serious injuriesLimited investigationFinal reportMichael J. Kohout Glassair III · Manassas, VAThe pilot's failure to maintain aircraft control while attempting an emergency landing after takeoff. Contributing to the accident was the pilot's inadequate preflight inspection and distraction due to a separated fuel cap in flight.NTSB ERA09LA111Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works SportCruiser · Emporia, VAThe student pilot's failure to maintain directional control during the landing. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information.NTSB ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.NTSB ERA09FA029Accident · 2 fatalField investigationFinal reportPiper PA-24 · Red Hill, VAThe pilot's failure to maintain aircraft control due to an improper repair to the stabilator, which resulted in an in-flight failure of the stabilator. Contributing to the accident was the descent in turbulence, at airspeeds above the maximum structural…NTSB MIA08CA191Accident · No injuriesData collectionFinal reportAirframes Unlimited USA-1B · Surry, VAThe pilot's improper handling of the powered parachute during takeoff/initial climb.NTSB NYC08CA294Accident · No injuriesData collectionFinal reportSacrey W Michael Zenair CH · Fincastle, VAThe pilot's inadvertent premature rotation during takeoff.NTSB NYC08CA236Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Front Royal, VAAircraft control was not maintained during cruise flight. Contributing to the accident was turbulence and inadvertent flight into adverse weather.NTSB MIA08LA105Accident · 1 fatalLimited investigationFinal reportAviate Raptor · Bealeton, VAAn in-flight loss of control for undetermined reasons.NTSB MIA08FA094Accident · 2 fatalField investigationFinal reportMooney M20M · Midlothian, VAThe pilot’s improper control inputs resulting from spatial disorientation.