NTSB investigations

19,222 cases where NTSB found Aircraft.

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\", '01'))
  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 CEN23LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Brookshire, TXThe P51 pilot’s failure to see and avoid the PA46 during taxi operations.Dec 27, 2022 · N282TX · 2 aircraft · Substantial damageNTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.Dec 26, 2022 · N210CU · Substantial damageNTSB WPR23LA075Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Dec 26, 2022 · N749PJ · Substantial damageNTSB ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.Dec 26, 2022 · N2895Z · Substantial damageNTSB CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.Dec 26, 2022 · N26625 · Substantial damageNTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.Dec 26, 2022 · N51115 · Substantial damageNTSB WPR23LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Livermore, CAThe pilot’s inadvertent use of the mixture control instead of the throttle, which resulted in fuel starvation and the subsequent loss of engine power.Dec 25, 2022 · N65Y · Substantial damageNTSB WPR23FA073Accident · 1 fatalClass 3 · FieldFinal reportCessna 150A · Santa Monica, CAA failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.Dec 22, 2022 · N7032X · Substantial damageNTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.Dec 21, 2022 · N321GD · Substantial damageNTSB CEN23LA067Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172F · Auburn Hills, MIThe catastrophic engine failure due to lack of oil lubrication, which resulted from the pilot’s failure to follow the airplane and engine manufacturers’ guidance for cold weather operation.Dec 21, 2022 · N8768U · Substantial damageNTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…Dec 20, 2022 · N2930J · Substantial damageNTSB WPR23LA085Accident · Minor injuriesClass 4 · LimitedFinal reportAuto-Gyro Cavalon · Benson, AZA loss of directional control on takeoff, which resulted in the collapse of the nose wheel strut and a runway excursion.Dec 19, 2022 · N518DT · Substantial damageNTSB CEN23LA066Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Harrison, ARA loss of engine power for reasons that could not be determined.Dec 19, 2022 · N8137P · Substantial damageNTSB WPR23LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Manual, AZThe pilot’s failure to maintain directional control during landing which, resulted in a runway excursion.Dec 18, 2022 · N4144P · Substantial damageNTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.Dec 18, 2022 · N78HJ · Substantial damageNTSB WPR23LA074Accident · Minor injuriesClass 4 · LimitedFinal reportRoyse Ralph L Glasair · Cottonwood, CAThe pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.Dec 17, 2022 · N9YA · Substantial damageNTSB ERA23LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172K · Brooksville, FLA hard landing that fractured the nose landing gear assembly, resulting in a loss of directional control and a nose-over.Dec 16, 2022 · N5405V · Substantial damageNTSB ERA23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Lexington, KYA main landing gear collapse due to a landing gear actuator overtravel for reasons that could not be determined.Dec 15, 2022 · N3844C · Substantial damageNTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.Dec 15, 2022 · N221MF · 2 aircraft · Substantial damageNTSB CEN23LA064Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206-L4 · Gulf of Mexico (Gulf of Mexico)The pilot’s improper takeoff technique that allowed the helicopter skid to drift into a helideck light, resulting in a dynamic rollover.Dec 15, 2022 · N414RL · Substantial damageNTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.Dec 15, 2022 · N991AB · Substantial damageNTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…Dec 15, 2022 · N13GZ · Substantial damageNTSB ERA23LA090Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · San Juan, PRThe pilot’s improper recovery from a bounced landing which resulted in a loss of control and subsequent runway excursion.Dec 14, 2022 · N416PC · Substantial damageNTSB WPR23LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 441 · Liberal, KSThe pilot’s inadequate preflight inspection, failure to set the parking brake, and his decision to exit the airplane with engines running to remove a wheel chock, resulting in the airplane’s unintended movement and subsequent collision with a hangar.Dec 13, 2022 · N253SB · Substantial damageNTSB WPR23LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA42 · Lewistown, MTThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the out of service visual glideslope indicator and snow obscuring the runway markings.Dec 13, 2022 · C-GZPU · Substantial damageNTSB ERA23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Rockingham, NCThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.Dec 13, 2022 · N498DS · Substantial damageNTSB ERA23FA087Accident · 1 fatalClass 3 · FieldFinal reportMooney M20B · Kellyton, ALA total loss of engine power due to fuel starvation.Dec 13, 2022 · N74586 · Substantial damageNTSB CEN23LA062Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Addison, TXThe fatigue failure of the engine’s camshaft gear teeth which resulted in a loss of all engine power. Contributing to the accident was the non-compliance with the engine manufacturer’s recommended service bulletin.Dec 13, 2022 · N231GZ · Substantial damageNTSB ERA23LA085Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Knoxville, TNThe pilot’s loss of directional control during engine start.Dec 12, 2022 · N783SF · Substantial damageNTSB ERA23LA084Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NYThe flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.Dec 11, 2022 · N14HT · Substantial damageNTSB WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.Dec 10, 2022 · N422B · Substantial damageNTSB ERA23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Alabaster, ALFailure of the tailwheel locking mechanism, which resulted in a loss of control during landing and a runway excursion.Dec 10, 2022 · N5301G · Substantial damageNTSB WPR23LA064Accident · No injuriesClass 4 · LimitedFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot’s failure to maintain directional control during the landing roll.Dec 9, 2022 · N190DK · Substantial damageNTSB ERA23LA083Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-44 · Hawkinsville, GAThe pilot’s inadequate in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Dec 9, 2022 · N160PT · Substantial damageNTSB WPR23LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna TP206A · Maricopa, AZA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s improper fuel management.Dec 8, 2022 · N30WL · Substantial damageNTSB WPR23LA061Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter EC 130 B4 · Waimea, HIThe pilot's loss of helicopter control on approach to land due to entering a vortex ring state condition, which resulted in a hard landing.Dec 8, 2022 · N130WS · Substantial damageNTSB ERA23LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Covington, GAA total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…Dec 8, 2022 · N900AW · Substantial damageNTSB ANC23LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Wasilla, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over after the main landing gear wheels broke through deep snow on the snow-covered runway.Dec 8, 2022 · N3861P · Substantial damageNTSB WPR23LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206-L4 · Ft Worth, TXThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident, was the flight instructor’s inadequate supervision.Dec 7, 2022 · N2036F · Substantial damageNTSB ERA23LA080Accident · Minor injuriesClass 4 · LimitedFinal reportJames R Dernovsek Kitfox · Woodsfield, OHThe pilot's failure to maintain directional control during the landing roll.Dec 5, 2022 · N257ED · Substantial damageNTSB CEN23LA061Accident · Minor injuriesClass 3 · LimitedFinal reportOrlican S R O M-8 Eagle · St. Louis, MOThe pilot’s failure to maintain adequate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall and hard landing.Dec 5, 2022 · N602TG · Substantial damageNTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.Dec 5, 2022 · N8149Z · DestroyedNTSB WPR23LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fergus Falls, MNThe pilot’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion.Dec 4, 2022 · N926HM · Substantial damageNTSB ERA23FA078Accident · 1 fatalClass 3 · FieldFinal reportRotorsport UK Cavalon · Beverly, MAThe pilot’s improper yaw control during the takeoff initial climb, which resulted in an excessive sideslip and a subsequent loss of aircraft control.Dec 4, 2022 · N401GR · Substantial damageNTSB WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.Dec 3, 2022 · N60WY · Substantial damageNTSB CEN23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108-3 · Regent, NDThe pilot failed to maintain clearance from high tension wires while maneuvering at low altitude.Dec 3, 2022 · N7659X · Substantial damageNTSB ANC23LA016Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Anchorage, AKThe pilot's loss of directional control during takeoff.Dec 3, 2022 · N8365V · Substantial damageNTSB ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.Dec 2, 2022 · N979RF · Substantial damageNTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.Dec 2, 2022 · N3515H · Substantial damageNTSB ERA23LA075Accident · No injuriesClass 3 · LimitedFinal reportGates Lear Jet 36 · Newport News, VAA left main landing gear tire rupture during takeoff, which resulted in a runway overrun.Nov 30, 2022 · N12FN · Substantial damage