NTSB investigations

176 cases where NTSB found Knowledge.

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\", '020320'))
  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 ANC11CA014Accident · No injuriesData collectionFinal reportCessna 172R · Montana Creek, AKThe pilot's failure to recognize that he was landing at the wrong airstrip on a snow-covered and unplowed runway, resulting in the airplane nosing over.Mar 5, 2011 · N447AF · Substantial damageNTSB WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.Dec 31, 2010 · N702FW · Substantial damageNTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.Aug 12, 2010 · N9353C · Substantial damageNTSB ANC10LA065Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's decision to make a low-altitude pass over a remote airstrip toward rising terrain in weather conducive to downdrafts.Jul 23, 2010 · N4590C · Substantial damageNTSB CEN10CA342Accident · Minor injuriesData collectionFinal reportVans RV-12 · Salida, COThe pilot’s incorrect elevator trim setting and his inexperience in the airplane make/model.Jun 24, 2010 · N29CA · Substantial damageNTSB CEN10LA335Accident · No injuriesLimited investigationFinal reportCessna 525A · Storm Lake, IAThe pilot’s decision to land on a water contaminated runway, which resulted in a runway excursion during the landing roll. Contributing to the accident was the pilot’s lack of knowledge regarding the landing distance required and the limited braking…Jun 21, 2010 · N800VT · Substantial damageNTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.Jun 4, 2010 · N421KB · Substantial damageNTSB ERA10FA259Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tuscaloosa, ALThe pilot's failure to maintain adequate airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin and collision with the ground.May 11, 2010 · N424LF · Substantial damageNTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…Feb 23, 2010 · N894CT · Substantial damageNTSB ERA10CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Highgate, VTThe pilot’s improper fuel management which resulted in loss of engine power due to fuel starvation.Oct 3, 2009 · N9237P · Substantial damageNTSB WPR10LA001Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Mitchell, ORThe pilot’s lack of understanding of the airplane’s fuel system, which resulted in a loss of engine power due to fuel exhaustion.Oct 2, 2009 · N1621C · Substantial damageNTSB ANC09LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Anchorage, AKThe pilot's unfamiliarity with the airport environment, which resulted in his taxiing the airplane onto a no-taxi section of roadway and into a road sign. Contributing to the accident was the pilot's failure to avail himself of additional information that…Jul 18, 2009 · N7136Q · Substantial damageNTSB ERA09LA400Accident · Serious injuriesLimited investigationFinal reportApollo Monsoon · Kanona, NYThe pilot's loss of control while landing in convective weather conditions. Contributing to the accident was his misjudgment of the approaching weather.Jun 26, 2009 · N308AA · Substantial damageNTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.Jun 20, 2009 · N2601 · Substantial damageNTSB ERA09LA357Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Chipley, FLA partial loss of power due to the use of automotive gasoline that contained ethanol, which was prohibited by the operating limitations. Contributing to the accident was the pilot/owner's failure to obtain and comply with the applicable operating limitations.Jun 19, 2009 · N41915 · Substantial damageNTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.Apr 27, 2009 · N6213G · Substantial damageNTSB ERA09CA232Accident · Minor injuriesData collectionFinal reportCessna 177RG · Ocean Isle Beach, NCThe pilot's failure to divert to an alternate airport resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot's incorrect determination of the fuel load prior to the flight, the lack of placards near the…Apr 4, 2009 · N1838Q · Substantial damageNTSB CEN09CA078Accident · No injuriesData collectionFinal reportCessna 172S · Waukesha, WIThe pilot's failure to maintain aircraft control during takeoff and his failure to ensure that the elevator trim was properly set before takeoff. Contributing to the accident was the pilot's lack of autopilot system knowledge.Nov 26, 2008 · N833SP · Substantial damageNTSB OPS09IA001Incident · No injuriesIncident investigationFinal reportPeoria, ILThe tower local controller's failure to provide adequate separation between EGF4075 and SKW5961 that landed on intersecting runways.Sep 22, 2008 · 2 aircraft · No damageNTSB DFW08CA229Accident · No injuriesData collectionFinal reportSukhoi SU-31M · Collinsville, OKThe pilot's failure to maintain clearance from marked transmission lines while on final approach.Sep 14, 2008 · N531MS · Substantial damageNTSB OPS08IA013Incident · No injuriesIncident investigationFinal reportPiper PA-46 · Fresno, CAThe tower controller's failure to ensure the runway was clear before allowing Skywest 69R to land. Factors contributing to the incident were the Malibu pilot's and tower controller's unfamiliarity with the airport layout.Aug 29, 2008 · N9219T · 2 aircraft · No damageNTSB LAX08PA259Accident · 9 fatalClass 1Final reportSikorsky S-61N · Weaverville, CAThe following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…Aug 6, 2008 · N612AZ · DestroyedNTSB ANC08LA085Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe pilot's improper fuel management which resulted in fuel starvation and a loss of engine power during cruise flight. Contributing to the accident was an aerodynamic stall during the emergency landing, the pilot's fatigue, and his unfamiliarity with the…Jul 4, 2008 · N80596 · Substantial damageNTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.Jun 20, 2008 · N3150U · Substantial damageNTSB NYC08LA165Accident · 1 fatalLimited investigationFinal reportDragon Fly GT-500 · Paris, TNA fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.Apr 21, 2008 · N101GP · Substantial damageNTSB NYC08LA099Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Leesburg, VAThe airplane's runway excursion during landing roll following an encounter with ice. Contributing to the accident was the ice-covered runway, and the airport personnel's lack of knowledge regarding the runway condition.Feb 13, 2008 · N16DK · Substantial damage