NTSB investigations

190 cases where NTSB found Low ceiling.

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03035010'))
  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 CEN10LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cedar Rapids, IAThe pilot's failure to maintain aircraft control while flying an instrument approach. Contributing to the accident was the pilot's lack of experience in actual instrument conditions.Jan 17, 2010 · N53120 · Substantial damageNTSB CEN10FA101Accident · 2 fatalField investigationFinal reportCessna 172 · Holland, MIThe pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…Jan 17, 2010 · N8405E · DestroyedNTSB WPR10LA103Accident · 2 fatalLimited investigationFinal reportLarson RV8 · Sequim, WAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.Jan 8, 2010 · N747CL · Substantial damageNTSB DCA10IA015Incident · No injuriesIncident investigationFinal reportBoeing MD · Charlotte, NCThe Captain's failure to initiate a go-around from a Category III approach when satisfactory tracking performance was not maintained below the required altitude resulting in excessive bank angle maneuvers at low altitude. Factors contributing to the incident…Dec 14, 2009 · N483A · Minor damageNTSB CEN10FA070Accident · 2 fatalField investigationFinal reportPiper PA-30 · Port Mansfield, TXThe pilot’s failure to maintain clearance with the water while on approach (VFR) to land.Dec 11, 2009 · N7781Y · DestroyedNTSB WPR10LA059Accident · 1 fatalLimited investigationFinal reportCessna 182K · Susanville, CAThe pilot's decision to takeoff into weather conditions conducive to ice accumulation, which resulted in an inadvertent stall/spin while maneuvering in the initial climb. Contributing to the accident was the likely accumulation of snow and ice on the airborne…Nov 20, 2009 · N2650R · Substantial damageNTSB CEN10LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Naytahwaush, MNThe non-instrument rated pilot's decision to continue the flight into known instrument meteorological conditions resulting in spatial disorientation and impact with terrain.Nov 14, 2009 · N7736N · DestroyedNTSB CEN10FA019Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Tahlequah, OKThe pilot's impairment due to recent heavy use of methamphetamine, recent use of a narcotic pain reliever, and fatigue. Contributing to the accident was the pilot's lack of instrument experience and training.Oct 14, 2009 · N3234G · DestroyedNTSB WPR10FA018Accident · 2 fatalField investigationFinal reportCessna 182 · Pryor, MTThe pilot’s decision to continue flight into an area of low ceilings and low visibility and his failure to maintain clearance from terrain.Oct 13, 2009 · N6202A · Substantial damageNTSB WPR10FA005Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Black Canyon City, AZThe pilot's decision to continue VFR flight into instrument meteorological weather conditions which resulted in controlled flight into terrain. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.Oct 4, 2009 · N7471P · Substantial damageNTSB ERA09FA537Accident · 3 fatalField investigationFinal reportEurocopter AS-350 · Georgetown, SCThe pilot’s decision to continue the visual flight rules flight into an area of instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and a loss of control of the helicopter. Contributing to the accident was the inadequate…Sep 26, 2009 · N417AE · DestroyedNTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…Sep 22, 2009 · N3234M · Substantial damageNTSB ERA09FA514Accident · 1 fatalField investigationFinal reportBeech A36 · Flat Rock, NCThe pilot’s attempt to maintain visual flight during instrument meteorological conditions, resulting in controlled flight into mountainous terrain. Contributing to the accident was the pilot’s failure to advise the controller of the weather conditions…Sep 10, 2009 · N888WD · Substantial damageNTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.Sep 5, 2009 · N1228H · DestroyedNTSB WPR09FA428Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Canyonville, ORThe non-instrument-rated and non-certificated pilot’s decision to continue visual flight into instrument meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain.Aug 30, 2009 · N2967P · Substantial damageNTSB WPR09FA385Accident · 1 fatalField investigationFinal reportCessna 182S · Napa, CAThe instrument-rated pilot’s loss of situational awareness and failure to follow the prescribed instrument departure clearance/procedure, which resulted in an in-flight collision with the terrain.Aug 5, 2009 · N23750 · Substantial damageNTSB CEN09FA340Accident · 2 fatalField investigationFinal reportGulfstream American AA-5B · Humbird, WIThe pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.Jun 7, 2009 · N448DM · Substantial damageNTSB WPR09GA216Accident · 3 fatalFinal reportLockheed P2V-7 · Stockton, UTThe flight crew's failure to maintain terrain clearance during low altitude flight in low ceiling and visibility conditions. Contributing to the accident was the flight crew's failure to adequately monitor their location with respect to the rising terrain…Apr 25, 2009 · N442NA · Substantial damageNTSB WPR09LA222Accident · 2 fatalLimited investigationFinal reportValentin Taifun 17 E II · Mammoth Lakes, CAThe pilot's failure to maintain clearance from terrain while maneuvering in a canyon.Apr 24, 2009 · N20822 · Substantial damageNTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.Jan 23, 2009 · N8298Z · Substantial damageNTSB ERA09CA134Accident · Serious injuriesData collectionFinal reportPiper PA-32R-300 · Manteo, NCThe pilot's failure to follow the missed approach procedure while landing with a low ceiling.Jan 13, 2009 · N7918C · Substantial damageNTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.Jan 4, 2009 · N815MA · Substantial damageNTSB ERA09LA123Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Powder Springs, TNThe non-instrument rated pilot's decision to continue under visual flight rules into an area of instrument meteorological conditions, which resulted in an in-flight collision with terrain.Jan 3, 2009 · N43631 · Substantial damageNTSB ERA09CA110Accident · No injuriesData collectionFinal reportCessna 172R · Morristown, NJThe flight instructor's failure to execute a missed approach when insufficient runway remained for landing. Contributing to the accident were the low ceiling and visibility conditions.Dec 27, 2008 · N178AF · Substantial damageNTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.Nov 11, 2008 · N2526V · Substantial damageNTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.Oct 24, 2008 · N7510Y · Substantial damageNTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.Sep 28, 2008 · N82TB · DestroyedNTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.Aug 24, 2008 · N5476P · Substantial damageNTSB DFW08FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Cassville, MOThe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…Aug 10, 2008 · N214MT · DestroyedNTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.Jul 27, 2008 · N75558 · Substantial damageNTSB LAX08LA213Accident · 2 fatalLimited investigationFinal reportSchweizer 269 C-1 · Sunol, CAThe pilots' failure to maintain adequate clearance from transmission wires during cruise flight. Contributing to the accident were the dark night and low fog.Jul 4, 2008 · N2011A · DestroyedNTSB LAX08LA154Accident · 1 fatalLimited investigationFinal reportMaule MX-7-235 · Boulder, MTThe pilot's decision to continue flight at low altitude in instrument weather conditions and his failure to maintain clearance from a power line. Contributing to the accident were low cloud and visibility conditions.May 23, 2008 · N5657Y · Substantial damageNTSB SEA08LA105Accident · 1 fatalLimited investigationFinal reportGlasair Glasair III · Cheyenne, WYThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, snow and whiteout conditions.Apr 7, 2008 · C-GGTM · Substantial damageNTSB MIA08FA080Accident · 2 fatalField investigationFinal reportCessna 182B · Wildwood, FLThe noninstrument rated pilot's failure to maintain terrain clearance at night in marginal visual flight conditions. Contributing to the accident was the dark night, and low cloud ceilings.Mar 16, 2008 · C-FFBC · No damageNTSB NYC08FA138Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Front Royal, VAThe pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…Mar 15, 2008 · N141SR · DestroyedNTSB DEN08FA059Accident · 2 fatalField investigationFinal reportCessna 414A · Benton, KSThe pilot's failure to maintain clearance from the trees. Contributing to the accident was the pilot's flight into known adverse weather conditions and the low clouds and visibility.Feb 17, 2008 · N41LP · DestroyedNTSB DFW08FA062Accident · 3 fatalField investigationFinal reportEurocopter France AS350B2 · S. Padre Island, TXThe pilot's failure to maintain aircraft control resulting in the helicopter impacting the water. Factors contributing to the accident were the pilot's inadvertent flight into instrument meteorological conditions, the low ceiling, dark night conditions, and…Feb 6, 2008 · N911VA · Substantial damageNTSB DFW08FA061Accident · 1 fatalField investigationFinal reportCessna 210 · Baytown, TXThe pilot's failure to maintain aircraft control after flying into clouds.Feb 5, 2008 · N968CC · DestroyedNTSB SEA08LA070Accident · 1 fatalLimited investigationFinal reportKidd Chris Harmon ROC · Maricopa, CAThe pilot's failure to maintain an adequate terrain clearance altitude while maneuvering in mountainous, hilly terrain. Contributing to the accident were hilly terrain, a low ceiling and gusty winds.Feb 2, 2008 · N96KR · DestroyedNTSB NYC08MA090Accident · 6 fatalMajor investigationFinal reportRaytheon C90A · Mount Airy, NCThe pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…Feb 1, 2008 · N57WR · Substantial damage