FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20070531010159ICessna 172H · Corinth, MS(-23) Aircraft landed short of the runway while performing a simulated engine out emergency approach and landing under the instruction of a CFI. [privacy data omitted]Incident 20070531008049IPiper PA24250 · Topeka, KS(-23) During a touch and go landing, the pilot selected the gear up instead of flaps up. The gear retracted during takeoff roll and while the aircraft was still on the runway. Damage was evident on the propeller and the belly skin of the aircraft.Accident 20070531007789ACessna A185F · ID(-23) During landing at the north star ranch, a Private airstrip, located on the selway river Idaho, the aircraft bounced and the left gear sheared off through the top two bolt holes that hold the wheel axle on the left main gear leg. The landing strip is…Incident 20070530019149IBeech 200BEECH · San Antonio, TX(-23) Aircraft was landed with the landing gear retracted. Pilot stated that he was distracted with a wing flap inop condition and was landing with more speed and power than usual. Landing gear warning horn did not sound due to flap position and throttle…Accident 20070530014559ACessna 340CESSNA · Middleton, WI(-23) Just after touchdown aircraft began to pull right and right wing began to drop. Pilot shut down engines as aircraft left runway and right main landing gear collapsed.Incident 20070530014389IConaer LA4 · Warriors Mark, PA(-23) Aircraft departed aoo. After approx. 20 minutes began to lose power, airspeed and altitude, landing in wheat field in nw huntington county with no injuries to the pilot.Incident 20070530013959IAmtr ZENITHCH701 · Mcdermitt, NV(-23) The pilot made a precautionary landing on a dirt road and drifted off the edge into a drainage ditch and an embankment.Accident 20070530013699AAmtr RV6A · Boerne, TX(-23) On may 30, 2007, approximately 1035 central daylight time, a single-engine adams RV-6A homebuilt airplane, N39AJ, was destroyed following a loss of control during initial takeoff climb from runway 04 at the John Henry Key Airport (7TA8) near Boerne,…Accident 20070530013049ADoug DC4 · Mcgrath, AK(-23) On may 30, 2007 at 1200 Alaska daylight savings time, a DC-4 airplane operated by brooks air fuel, fairbanks, Alaska sustained substantial damage during landing at the Nixon Fork Mine Airport (private airport). The right main landing gear struck the end…Accident 20070530012509ACessna 170B · Pahokee, FL(-23) On Wednesday, may 30, 2007, at about 1550 LCL Cessna 170, N1767D piloted by [privacy data omitted] departed pbi and landed at phk under heavy crosswind (as he reported to me over the phone). The pilot ended up hitting the ground with the right wing and…Incident 20070530012369IPiper PA28R200 · Oceanside, CA(-23) Pilot performed a touch and go at fall brook airport. He then proceeded to Oceanside airport. He lowered the gear, observed gear safe light indicators, and attempted to land. As he flared just prior to landing, the main gear touched down. As he lowered…Accident 20070530012149APiper PA32300 · Columbia, SC(-23) On touchdown, nose fork failed. Prop strike occurred, nose raised and tail section struck runway causing damage to last bulkhead and lower skin. Nose gear fork is being inspected by NTSB. Received call from NTSB stating that the fork broke due to a hard…Incident 20070530011979IBeech 58TC · Port Lavaca, TX(-23) Pilot stated that while on final approach, he selected gear down. Two main gear down and lock lights illuminated. The nose gear down and lock light did not illuminate. Pilot checked light to make sure it was working, it was. Pilot pulled landing gear…Incident 20070530011439IDoug MD1010F · Fort Worth, TX(-23) Upon landing at afw, crew deployed thrust reversers. After deployment, thrust reverser #2 would restow. When aircraft arrived at ramp, it was discovered that the #2 engine thrust reverser translating sleeve had departed from engine and landed on runway.Incident 20070529013859ICessna 172RG · Greeley, CO(-23) Spot landings were conducted to an aim point at the 1,000 ft remaining marker on runway 16. The main gear was in the trail position at touchdown as noted by the skid marks at 2 to 2 1/2 feet apart from touchdown to the exit point on the right side of…Accident 20070529013429AHughes 369D · Torrance, CA(-23) During hover practice at toa near the helicopter practice pad, the PIC lost control and the helicopter made a hard landing. The helicopter sustained substantial damage. Wind gusts were reported at the time which the PIC feels was a contributing factor.Incident 20070529011079IPiper PA31P350 · Glennville, GA(-23) N454SC a P31 landed ft. stewart moa due to fuel depletion.Incident 20070529010999ICessna 152 · San Diego/El C, CA(-23) The pilot in this incident is a student pilot and was on her second supervised solo flight, practicing takeoffs and landings. Upon landing, she exited the runway at a high rate of speed, ran off the edge of a taxiway and hit a directional sign. The…Accident 20070529010929AHughes TH55 · Las Piedras(-23) On 05/29/2007 at approx. 9:30 am the pilot [privacy data omitted] was flying his helicopter when after takeoff, and approx. 350 ft the engine lost power. To avoid power lines the pilot [privacy data omitted] made a turn and continued his autorotation to…Accident 20070529010809AAirtrc AT502B · Robstown, TX(-23) While conducting aerial application operations, the pilot [privacy data omitted] misjudged the distance between two sets of power lines. The pilot [privacy data omitted] struck the power lines with the vertical stabilizer of air tractor, N502DB, cutting…Incident 20070529010589IPiper PA32RT300 · Coolidge, AZ(-23) Landing runway 23 at P08. Pilot conducted pre-landing checklist, and noticed 3 green lights for landing gear. His passenger commented about gumps, and pilot showed him the 3 green lights were illuminated. Pilot made a normal landing. During rollout, he…Incident 20070529008829IBeech M35 · Roseburg, OR(-23) Aircraft departed 3S8 enroute pwt. Pilot reports landing gear did not retract. After extending landing gear pilot executed a fly-by at rbg while ground personnel verified that the landing gear appeared to be fully extended. Aircraft landed without…Accident 20070528014709ACessna 182S · Grafton, WI(-23) Pilot was on a trip to visit relatives with three pax. He stated he circled the airport and determined runway 36 looked the best, with wind not a factor. He stated that he flared high, then touched down in a three-point position, porpoising about five…Accident 20070528013819ACessna A185F · Wilbur, WA(-23) Airman departed to the east from personal airstrip, according to his spouse, between 1500 and 1530. Aircraft is subsequently discovered 1/4 mile north of the departure end of the runway. The left wing struck the ground first, with the aircraft then…Incident 20070528012459IAmtr Glasairirg · Reno, NV(-23) The pilot departed bke for the approximate 2 hour flight to cxp. During the approach to cxp, the pilot selected gear down and noticed an unsafe gear condition. The pilot stated the gear hydraulic pressure appeared correct; however, the right main showed…Accident 20070528011329AHughes 369D · Broadview, MT(-23) On may 28, 2007, at 1:30 pm, mountain time, a Hughes HU-369-D helicopter, registered to dylan aviation, LLC, was engaged in power line inspection, and had a loss of power crashing from a hover of 150 feet above ground level (AGL). The pilot and one…Accident 20070528011259APiper PA24250 · Mammoth Lakes, CA(-23) The accident pilot was taking off from Mammoth Lakes, CA airport to the east. Shortly after lifting off he saw another aircraft that had just lifted off from the opposite runway coming directly at his aircraft. He immediately dropped the nose which…Accident 20070528010779ACessna 180H · Grand Junction, CO(-23) The pilot stated as he lifted tail during take off a gust of wind lifted the left wing, left aileron was applied and as the wing came down the power was reduced but the aircraft made an immediate left turn off the runway. The aircraft rolled off the…Incident 20070528010019IDhav DHC6300 · Chula Vista, CA(-23) This incident involves a skydiver [privacy data omitted] conducting parachute jumping activity under 14 CFR part 105. Witness statements indicate that [privacy data omitted] exited the aircraft at approximately 12,500 MSL. One witness statement…Incident 20070528010009IAmtr RV8 · Evergreen, CO(-23) Pilot stated engine failed between Continental divide and centennial airport. Magneto failure causing total engine failure resulting in off airport forced landing. Single drive magneto system. No damage or injury.Incident 20070528009749IAmtr Ctsw · Groveland, CA(-23) R/h landing gear assembly failed on landing. Wheel assembly separated from leg strut at lower attachment point (fracture at lower bolt holes).Incident 20070528009609ITaft, CA(-23) A skydiver suffered fatal injuries following apparent equipment malfunction after parachute deployment. Witnesses observed the main chute open at approximately 2500' AGL followed by the skydiver attempting to release it for unknown reasons. Thereafter,…Accident 20070528008199ACessna TU206G · Napa County, CA(-23) N7395C departed concord, CA airport at approximately 0715 hrs 5/28/2007. A few minutes later after attaining 4000', the engine started running rough. The pilot was in the process of making a decision to return to concord to have the engine checked. The…Incident 20070528007639ICessna 177RG · Kernville, CA(-23) PIC was distracted by another aircraft in the pattern he was watching closely, and mountainous are in close proximity. Did not hear "low manifold pressure with landing gear up" aural warning, if it operated, because he was wearing a headset. Had made…Accident 20070528007489ACessna 182G · Moab, UT(-23) Aircraft departed Moab (Canyonlands-cny) runway 03 with an early right turn out to the southbound in a climb. Aircraft made a left turn to a north heading, then left wing dropped and nosed down. Aircraft hit the ground left wing & left main gear…Incident 20070528007289IBeech H35 · Eugene, OR(-23) A Beechcraft bonanza H35 (N353B) landed at Eugene Oregon on runway 34R, during rollout after landing the nose gear slowly collapsed resulting in propelle striking the ground and a sudden engine stoppage. Pilot had noticed that prior to landing…Accident 20070527019329AAmtr RV6A · Summerville, GA(-23) On may 27, 2007 a RV-6 crashed while attempting to land at Wyatt field (GA-23) Summerville, GA. On second landing attempt pilot stalled the aircraft resulting in hard landing. The nose gear collapsed and the aircraft flipped on its back.Incident 20070527018749IHughes 369E · Earp, CA(-23) Pilot made a precautionary landing on dirt road 2 miles north of airport reportedly due to abnormal cyclic pressure and pilot reported he was concerned about complete trim failure, so he landed. Tail rotor blades were reported as damaged, NTSB…Incident 20070527014399IBeech 1900D · Lebanon, NH(-23) This office notified by new england region operations center that: "colgan 4833, BE1900, laguardia, NY to Lebanon, NH shutdown the right engine for low oil pressure. Aircraft landed runway 18 without incident at 1627 EDT, 5/27/07. This inspector spoke…Accident 20070527012199ABolkms BO105CBS · Vieques, Puerto Rico(-23) Helicopter was taking off from small hospital landing area. Upon takeoff, pilot noticed partial power loss/engine failure. Pilot commenced an autorotation, at less than 100' AGL. Helicopter contacted the ground slightly to the right and hard.…Accident 20070527011359ABell 47G · Hayden, AL(-23) On may 27, at approximately 1005 CDT, the student pilot was relocating his newly acquired helicopter from a trailer parked in front of his residence to a landing area behind the house. The take off from the trailer was uneventful and he circled around…Accident 20070527009599AAmtr RANSS6S · Newark, IL(-23) Note: this form does not have a box for certificate type of sport pilot. The pilot [privacy data omitted] held a sport pilot certificate. Witness interviewed by lasalle county sheriff said the aircraft climbed quickly just after take off (heading 090)…Accident 20070527009569ADoug MD500E · Yerington, NV(-23) The pilot in command stated the flight involved training in preparation for a certification test for the second pilot. A low level, power off autorotation to a power recovery was planned and attempted. Sufficient power to sustain flight was not…Accident 20070527009549ASchler ASW24 · Williams, CA(-23) N5LX a schleicher ASW-24 glider was enroute to its base of operations when the aircraft stalled due to lack of lift and crashed. The wings sustained substantial damage and fuselage was damaged.Incident 20070527008859ICessna 172S · Olathe, KS(-23) The pilot [privacy data omitted] conducted an introductory flight lesson with a first time student in the left seat, and one passenger in the back of the single engine Cessna 172. After landing and clearing the runway, he instructed the student to turn…Incident 20070527007619IBbavia 8KCAB · Yerington, NV(-23) The pilot on performing a landing and during roll out was hit by a large "dust devil" that caused lateral loss of control. Aircraft veered off to left side of runway and subsequently had a prop strike on rocks and loss of the front portion of right…Accident 20070526015479AAmtr Searey · Freeport, PA(-23) Weather at the time of the accident was VFR, wind was calm. N4801W is an experimental amateur built amphibious airplane. The pilot [privacy data omitted], builder of N4801W, stated that the approach to a downstream landing in the pool below lock and dam…Incident 20070526012009IPiper PA28140 · Landrum, SC(-23) PIC reported smoke in the cabin and engine power loss in flight. Pilot diverted his route of flight to land at the nearest suitable airport which was Fairview Airport, Landrum, SC (33A). Due to the heavy amount of smoke in the cabin his approach to land…Accident 20070526010229ABrasov IS28B2 · Mokuleia, HI(-23) This accident occurred on may 26, 2007, at Dillingham, airfield, at approximately 1420 local time. Aircraft involved: Brasov, IS-28-B2 (glider), registration # N1052Y. During an auto tow departure off of runway 8, at midfield the tow rope broke, the…Incident 20070526009729IBeech C24R · Long Beach, CA(-23) On may 26, 2007, at approximately 1135 (PDT), while landing at Long Beach airport, California, under the provisions of 14 CFR part 91, pilot landed hard and bounced on runway 25L. As a result the nose landing gear drag link and yoke failed, and the…