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.
Accident 20070619014939ACessna 195 · Battle Creek, MI(-23) Aircraft experienced hard-landing on runway, ground looped, exited runway damaging left wing and collapsing left landing gear.Accident 20070619014119AMooney M20E · Van, TX(-23) On June 19, 2007, at approximately 15:30 local time, Mooney aircraft model Mooney-20-3, serial number 627, N115RC departed airport 5XS5, VMC weather conditions prevailed and no flight plan was filed. Shortly after lift off, the aircraft veered to the…Accident 20070619012639ACessna U206D · Homer, AK(-23) On a part 135 flight from seldovia AK to Homer AK the engine quit over yucon island. The pilot attempted to make an emergency landing on the south east beach of the island. The aircraft was in a steep right bank lining up with the beach, flight heading…Accident 20070619011699AAmtr Flightstar · Nampa, ID(-23) On a local flight from the Nampa airport at app 2130 pilot stated he reduce power from 4600 RPM to 3200 RPM and the engine just stopped running. He then made an emergency landing in a field 6 miles south of the Nampa airport hitting a ditch on…Accident 20070619011209AWaco UPF7 · Reno, NV(-23) Aircraft ground looped while landing at Reno-Tahoe international airport. Substantial wind damage occurred on the lower right wing.Incident 20070619010629ICessna 182P · Jefferson City, MO(-23) After landing on runway 12, the pilot stated that the aircraft pulled to the left immediately and the brakes were unresponsive. As the airplane veered toward the left side of the runway, the pilot added power to abort the landing. As the airplane became…Incident 20070619010169ICessna 414 · Salmon, ID(-23) Cessna 414, N414PC, s/n 4140266 on IFR flight plan from las vegas NV to Salmon id landed gear up on runway 17 Salmon id. Pilot stated he lowered flaps and adjusted airspeed for approach and then lowered landing gear but did not check to see if he had…Incident 20070618826249IHughes 369D · Huntington Twn, OH(-23) Immediately following a power check at 70% torque at 500' AGL, the engine lost power and spooled down. The pilot then executed a successful autorotation into a field.Accident 20070618020549APiper PA31310 · Mount Joy/Mari, PA(-23) The subject aircraft touched down two feet short of the runway threshold resulting in the main landing gear lower struts impacting the pavement edge. The left lower strut separated from the aircraft and the right bent over and continued supporting the…Accident 20070618018589ACessna 172 · Brinson, GA(-23) Pilot said he had taken off from his private strip on a joy ride, and was flying for about an hour. He said that when he was about 2 miles out from his field the engine power was greatly reduced and he estimates he has about 20 percent power. He said…Incident 20070618015759ICamron N120 · North Coventry, PA(-23) As related during a telephone conversation with the PIC, on June 18, 2007 at approximately 1950 EDT, he landed due to winds increasing towards landing limits. PIC briefed the six (6) passengers for a high wind/rough landing and touched down in the North…Accident 20070618015589ABeech C23 · Plainville, CT(-23) On 06/18/07, at approximately 1310 hours EST, aircraft registration N67248, Beech model number BE-23-C23, upon landing, departed runway number 02 to the right embankment at midfield from a loss of control by the pilot in command. The PIC departed the…Accident 20070618013409ACessna 182D · Phoenix, AZ(-23) On take off at dvt on runway 25L, the aircraft lost power. The pilot initiated an emergency landing on the remaining runway, landing hard and coming to rest in the runway overrun area. The hard landing buckled the firewall and cabin floor. Post accident…Incident 20070618012439IFound FBA2C1 · Spokane, WA(-23) On June 18, 2006 at 12:50 the pilot [privacy data omitted] was acting as pilot in command of N889WT, a single engine Found FBA-2-C1 airplane configured on amphibious floats. This particular FAR 135 flight for hunter air inc. cert. #Z8WA, originated at…Incident 20070618012409ICessna R182 · Mount Sterling, KY(-23) Due to piston rack gear failure in the left main gear actuator, pilot was unable to extend the left main landing gear using normal or emergency gear extension procedures. Pilot accomplished a gear up landing as directed in the pilot's operating…Accident 20070618012109AAmtr Hawkarrow · Southern Pines, NC(-23) On June 18, 2007, approximately 2020 EDT, a hawk arrow tandem registered to [privacy data omitted] was piloted by [privacy data omitted]. The aircraft was in flight approximately 5 miles from moore county airport in Southern Pines, NC at 1200 feet when…Accident 20070618011199ACessna 177RG · Oceanside, CA(-23) On June 18, 2007, about 1845 pacific standard time, a Cessna 177RG, N2144Q, experienced a loss of engine power and struck a car during an emergency landing on interstate 78, in Oceanside California. During an interview conducted by the FAA iic, the…Accident 20070618010869ABeech T34A · Laurinburg, NC(-23) Aircraft departed pit enroute to vero beach, Florida with a planned fuel stop at the Laurinburg-maxton airport (meb) in Laurinburg, NC. While turning downwind to base at meb the pilot experienced an engine failure. Pilot safely landed in a field near…Incident 20070618010009IAmtr LC41550FG · Sedona, AZ(-23) After landing at the Sedona, Arizona airport (sez), while braking the right main tire blew and caused damage to the wheel pant and landing gear leg fairing.Incident 20070618009699IPiper PA24260 · Moses Lake, WA(-23) Upon touchdown airman inadvertently raised landing gear while attempting to select flaps up, to achieve better braking. Landing gear retracted and aircraft settled to rest on the fuselage. Aircraft was subsequently removed from runway for repair.Accident 20070618009439AAmtr ROTORWAY162F · Logan, UT(-23) Aircraft clutch was disengaged accidentally by pilot and autorotation was successful, and after landing on slope crushing a skid, aircraft rolled over.Incident 20070617825429ICessna 182L · Marshall, WI(-23) On June 17, 2007, at approximately 1700 cdlt a skydiver received multiple injuries when he impacted the ground after a partial chute opening due to tangling with another diver's chute. Visual meteorological conditions prevailed at the time. A flight…Incident 20070617825359ICessna 210L · Cincinnati, OH(-23) While in the traffic pattern at kluk the pilot failed to lower his landing gear after being cleared for the option on runway 03L. The aircraft landed gear up.Incident 20070617825059IBoeing 777222 · Chicago, IL(-23) United airlines flight 149 departed kord at 15:55 pm CDT. Co-pilot suffered an apparent stroke. Flight returned to kord at 17:00 CDT. Emergency services transported the co-pilot to resurrection hospital.Incident 20070617019789IBbavia 7AC · Waynesburg, PA(-23) On June 17, 2007, Aeronca 7AC, N83588, operated by the pilot [privacy data omitted] received minor damage during landing, runway 27 at Greene County airoprt (way). The pilot stated the aircraft bounced and headed to the right. Damage was limited to a…Incident 20070617012849IAmtr KR2 · San Jose, CA(-23) On June 17, 2007 the pilot of N5304J, a KR-2 homebuilt aircraft was landing at Reid-Hillview airport when the landing gear collapsed. In a statement from the pilot on a 6 mile final to 30L, he partially lowered the landing gear to act as a speed brake.…Accident 20070617012539AUnivar 1082 · Washington, NC(-23) On June 17, 2006 the pilot, (non-certificated) and one passenger took off from ocw (Washington, NC). On climb out, engine lost power and pilot attempted to land in field. Aircraft impacted ground and sheared right main landing gear and ruptured right…Incident 20070617011599IPiper PA30 · Palm Springs, CA(-23) Left tire blew on rollout after landing.Accident 20070617010959ABeech B24R · Tonopah, NV(-23) Sequence: the accident aircraft, N6511R landed at Tonopah Airport, NV (ktph) and was provided service from an airport FBO. At 1933 UTC, N6511R was serviced with an additional 10 gallons of fuel which placed the airplane at its maximum gross weight for…Incident 20070617010499IAMD Falconf · Grand Island, NE(-23) N205JC, Amd-20-F, being operated as a part 91 flight landed in Grand Island, NE for fuel. As the aircraft turned off the runway to the taxiway, the cabin started filling with smoke. Due to the smoke in the cabin, the captain stopped on the taxiway and…Accident 20070617010279AAmtr Avidflymkiv · Dubois, WY(-23) Engine quit and aircraft was forced landed on a country road. Right landing gear sheared at weld on axle causing substantial damage.Incident 20070617009759INamer AT6F · Knights Perry, CA(-23) On Sunday June 17, 2007, at approximately 1420 PDT, a north American T-6, N75AG flew low over the water at tulloch, lake bordering the California county lines of tuolumne and calaveras. The airplane departed columbia airport a few minutes earlier after…Incident 20070616020269ITcraft BC12D · Belle Chasse, LA(-23) Pilot was in the process of taxiing to seaplane ramp. Left float dug into the mud adjacent to the bank, causing the aircraft to veer to the left and nose over. [privacy data omitted]Incident 20070616016629IPiper PA25 · Stone Harbor P, NJ(-23) Aircraft departed green creek, NJ, green creek landing strip (JY04). After 35 minutes of banner towing at approximately 500 hundred feet, engine started to run rough north of hereford inlet, NJ. The pilot landed on the beach in Stone Harbor point, NJ.…Incident 20070616015729IAmtr Kitfoxspeeds · Fairfax, VT(-23) The pilot [privacy data omitted], pilot in command of Kitfox 43KA, made an emergency landing in a field. The aircraft lost power due to fuel depletion. [privacy data omitted]Accident 20070616015169AAmrgen AA1 · Chicago, IL(-23) Pilot was performing touch and goes on runway 36 at Lansing airport, IL (igq). Taking off on runway 36 engine stopped running. An off airport landing was attempted at a golf course nearby.Accident 20070616014919AAmtr Apachequest · Charleston, NH(-23) Accident occurred June 16, 2007, in the Connecticut river near springfield VT and Charleston NH. The aircraft (a elsa weight shift trike) departed from the morningside flight park in Charleston, NH. Aircraft is a 2001 experimental light sport north wing…Incident 20070616014369IPiper PA34200T · Devine, TX(-23) On June 16, 2007, a Piper seneca landed at the Devine airport (23R), at approximately 2:30AM during a thunderstorm and went off the south end of the runway through two fences, damaging the airframe, engines and props with barb wire and fence posts. The…Accident 20070616013669APiper PA12 · Riggins, ID(-23) Upon landing at sluice creek emergency airstrip in hells canyon the left main gear tire hit a rock that collapsed the left landing gear aft tube resulting in the main gear coming up and bending the left forward wing strut.Accident 20070616013279AGrob G102STDAST3 · Wickenburg, AZ(-23) On June 16, 2007, the pilot [privacy data omitted] was completing a four hour cross-country flight in a Grob G102 sailplane, N123KG. At approximately 4:15 pm and 20 miles northwest on home base he ran out of lift. He saw date creek a Private landing…Accident 20070616012909AAmtr NIMBUS3DM · Genoa, NV(-23) While attempting to return to the minden-tahoe airport for landing, the pilot reported that he was caught in a downdraft and realized he could not make the field. He elected to land his glider in an alfalfa field, approximately four (4) miles west of…Accident 20070616012549ABnorm BN2A26 · Egegik, AK(-23) This was an on demand charter flight conducted to a beach landing site near Egegik, Alaska. The pilot reported the sand softer than normal causing the nose wheel to dug in on roll out. The pilot inspected the nose gear and only found a small dent in the…Incident 20070616011169ICessna 182Q · Pahokee, FL(-23) On June 16, 2007 at approximately 0915 eastern standard time a Cessna 182, operating under title CFR 91 departed north palm beach county airport (KF45). One pilot and two passengers were onboard. The weather was VMC at the time of the incident. The…Accident 20070616010979ABeech 58 · Placitas, NM(-23) On June 16, 2007 at 1610 MDT a Beechcraft BE-58 baron, N6750R, collided with terrain at 9700 feet MSL while in cruise flight. The aircraft was destroyed and the private pilot, the only occupant, was fatally injured. The flight had departed torrance, CA…Accident 20070616010309ACessna 180H · Star, ID(-23) The pilot stated that while enroute to nampa, the engine failed due to fuel starvation. The pilot elected to land on a road. On landing rollout, the pilot intentionally left the road to avoid traffic, causing the aircraft to flip over.Accident 20070616010289AAmtr Europaxs · Livermore, CA(-23) The aircraft departed runway 25R heading west. The aircraft climbed to an altitude of between 300 & 400 feet above an adjacent golf course just after take-off at an estimated 5 degree pitch up and a slow speed. The aircraft turned left 90 degrees in a…Accident 20070616009099AAmtr RV8 · Wilsonville, AL(-23) Pilot in command allowed the aircraft to bounce during an attempted landing. Elected to perform go around, applying full power in a nose high, low airspeed configuration. Pilot in command was unable to maintain directional control, creating extreme side…Accident 20070615014679ACessna 150H · Bellaire, MI(-23) The pilot stated that on the approach the aircraft appeared to be descending at a higher than normal rate. When application of power was attempted the engine did not respond. The pilot further stated that she was unsure as to the position of the mixture…Accident 20070615014659ACessna 172S · Batavia, NY(-23) On June 15, 2007 at approximately 1930 local a Cessna 172, N2228L sustained substantial damage during a hard landing on runway ten (10) at Genesee County Airport, Batavia (gvq), NY. The pilot was a student on his first solo. The student stated that the…Accident 20070615013369ACessna 150J · Oahu, HI(-23) Aircraft involved: Cessna, CE-150-J, registration #N60020. This accident occurred on June 15, 2007, southwest of koko head on the island of Oahu at approximately 1752 local time. Proceeding inbound to the honolulu international airport, at approximately…