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 20070718014099AAmtr PHANTOMX1 · Anderson, AL(-23) While taking off from a private air strip, the aircraft stalled, banked to the left and struck a house. Aircraft received substantial damage and minor damage to the house was reported. The pilot received minor injuries as a result of this incident.Incident 20070718014089ICessna 172RG · Cedar City, UT(-23) The instructor [privacy data omitted] was giving instruction to a commercial pilot [privacy data omitted]. The aircraft was landed with the landing gear in the up position. The instructor [privacy data omitted] said he would accept responsibility for…Incident 20070718013919ICndair CL6002B19 · Lincoln, NE(-23) N932SW, CL-600-2B19 was operated as united express flight 6245, enroute from Lincoln, NE to chicago, IL. Climbing thru 11,000 the crew received an APU oil caution message. The flight returned to lincolne, NE. Company maintenance replaced the APU low oil…Incident 20070718013169ICndair CL6002B19 · Tulsa, OK(-23) On July 18, 2007, N8790A, flagship flight 5681, a northwest airlink flight, operated by pinnacle airline, inc., departed tul, OK at approximately 0730. During take off a strong burning smell on the flight deck was noted and an open door indication was…Incident 20070718012759IUnivar 415C · Albuquerque, NM(-23) Due to a low-fuel indication, the PIC elected to make a precautionary landing on the frontage road, north of interstate I-40, 6 miles west of Albuquerque, NM. The landing was made without incident, the NM state police assisted the PIC in obtaining auto…Incident 20070717825719IAerstr S81A · Pringle, SD(-23) On 7/17/07 at 0700 a balloon owned by black hills balloons landed hard during an air tour flight. The aircraft was not damaged, and one passenger sustained a sprained ankle. The pilot held a commercial certificate. The flight originated at custer, SD…Incident 20070717020329ICessna 180 · Anchorage, AK(-23) Pilot departed runway 25 for ship creek departure. At about 400 feet AGL aircraft lost power, and pilot pushed engine controls full forward, checked fuel selector and radioed Merrill tower his intention to land. Tower cleared for any runway. Pilot…Incident 20070717019179IPiper PA28161 · Meriden, CT(-23) After refueling the aircraft the pilot taxied to the north end runway (18) for takeoff. Due to incoming traffic he decided to taxi back to the south end for departure. While still on the taxiway at the south end of the runway (36) the aircraft's engine…Accident 20070717018109APiper J3C65 · Uxbridge, MA(-23) Aircraft suffered power loss at approximately 100' AGL. Pilot initiated a right turn and impacted trees. No injuries, aircraft substantially damaged. Aircraft was stuck in trees until trees were cut down. Fuel onboard approximately 7-8 gallons. No water…Incident 20070717016999ICessna 152 · Atwater, CA(-23) 1St solo flight for student pilot. Hard landing with porpoising caused nose wheel to separate from the gear.Incident 20070717016179IBeech A36 · Caldwell, NJ(-23) N525RR landed long according to personnel of cdw tower, rolled off the end of runway 22, and became stuck in the grass at the end of the runway. The pilot attempted to move using aircraft power but could not due to a flat tire. The aircraft was…Incident 20070717016169ITitan T51MUSTANG · Glendale, AZ(-23) The pilot, after flying in the local Glendale, AZ area, was in the process of making his landing/touch down at Glendale airport (geu) when the landing gear retraction system failed, collapsing both main and tail wheel simultaneously. The aircraft slid…Accident 20070717016039AAirtrc AT802A · Winnemucca, NV(-23) Tanker 458, crashed while fire fighting in spaulding canyon 20 miles south of Winnemucca, NV. Aircraft was destroyed. The pilot was interviewed by the pershing county sheriff department at the crash site. The pilot's statement is as follows: that during…Incident 20070717015229IBeech 1900D · Omaha, NE(-23) On Tuesday July 17, 2007, U.S. Airways/air midwest BE-1900D operated as flight 4744 at Eppley Airfield, Omaha, NE. Flight 4744 was parked near jet bridge gate 18 and approximately 20:38 CDT flight 4744 began taxiing (immediately after southwest flight…Incident 20070717014249IPiper PA28236 · Novato, CA(-23) Aircraft landed on runway, then rolled off the end of runway and struck a dirt mound. Nose gear strut was broken off causing propeller damage and sudden engine stoppage.Incident 20070717013869IMooney M20R · Atlanta, GA(-23) Concluding a VFR flight from blairsville, GA (46A), N700RT, a Mooney M20R, overshot runway 20R at Dekalb-Peachtree Airport (pdk) after landing. Runway 20R is paved, 3755 ft long, 150 ft wide, and served with a precision approach path indicator (PAPI).…Incident 20070717013839IAmtr 173RGVELCITY · St Augustine, FL(-23) After local flight pilot landed aircraft. After landing he felt an unusual vibration. The pilot thought the landing gear was going to collapse and initiated a go around. While in the traffic pattern the pilot inspected the landing gear. After landing a…Accident 20070717013379ARobsin R22BETA · Bend, OR(-23) After the sixth practice autorotation, aircraft landed hard at the termination of a 180 degree left-hand autorotation. Pilot stated that the aircraft accelerated in a nose-down attitude, aft cyclic and collective application did not arrest the rate of…Accident 20070717013009ABeech E33C · Laurel, MT(-23) On July 17, 2007, at 1425 hours, mountain time, a Beechcraft bonanza, N7927R, registered to rocky mountain college, incurred a nose gear collapse after touchdown, while rolling out at the Laurel Municipal Airport in Laurel, Montana, while on a training…Incident 20070717012719IBeech B200 · Houston, TX(-23) Pilot initiated take-off power and rotated at 96 KTS at 50 feet airspeed indicated 100 knots aircraft yawed left and airspeed decreased. Pilot feathered left engine and made a hard left turn and landed in grass adjacent to 12 r south of…Incident 20070716826099IPiper PA28180 · Paulding, OH(-23) Aircraft landed on runway 27. Pilot reported he touched down in the center of the grass runway. The pilot stated he took his feet off the rudder pedals to apply the brakes and the aircraft drifted to the right. The aircraft departed the runway and…Incident 20070716825439IBoeing 737524 · Chicago, IL(-23) On Monday July 16, 2007 the ord-fsdo received a phone message from Midway international airport operations that a Continental airlines 737, flight #1196 hit a jet way. Inspection on aircraft N32626, serial number 27530 revealed that the aircraft was…Accident 20070716019289AAmtr Mustangmidgt · Lorain/Elyria, OH(-23) On the initial test flight the pilot stated that at liftoff (on runway 25) at klpr, the engine sputtered and lost power. The pilot stated he decided to land in the grass adjacent to the runway. The aircraft sustained substantial damage to the propeller,…Accident 20070716018829AAmtr ROTORWAY162F · South Heart, ND(-23) While conducting a part 91 cross country flight at approximately 400 feet AGL the pilot stated he inadvertently struck the engine fuel pump switch while taking a drink of water. This resulted in the engine failure. There was insufficient altitude for…Accident 20070716018819AAmtr Quicksilver · Lake City, MN(-23) While in level flight, the unregistered aircraft (ultralight) struck a tree and then crashed to the ground from approximately 30 feet AGL. Operator of the aircraft sustained critical trauma injuries to the head and thorax and is not expected to survive.…Accident 20070716017129AAirtrc AT402A · Laurel, IA(-23) Agricultural aircraft was traveling between fields in cruise flight, then impacted the ground in a nose low attitude at a time when the aircraft was not dispensing chemicals. Engine appeared to be developing power, flight controls had continuity and no…Accident 20070716015039ABell 206B · Dillon, MT(-23) At approximately 0830 hours on July 16, 2007, at location 15.5 miles northwest of the island park reservoir, on the Montana side of the montana/idaho state line, while conducting a helicopter external load operation, the pilot was back-hauling an empty…Incident 20070716013979IAmtr Americansprt · Salida, CO(-23) While attempting to land, a strong gust of wind caught the aircraft. He lost control which resulted in the left wing tip making contact with the ground. The landing ended with the aircraft ground-looping. Thunderstorms and strong, turbulent winds…Accident 20070716013709ACessna A188A · New Hartford, MO(-23) Pilot said he "lost air." He said he was finishing a level turn to return to the field he was spraying when the airplane clipped a tree. The pilot said the aircraft was not producing the lift at full power to climb above the trees at the FAR end of the…Incident 20070716012689ILkheed P2V7 · Missoula, MT(-23) On July 16, 2007, at approximately 12 pm, mountain time, a Lockheed P2V-7 aircraft, N14447, operated by neptune aviation services, a title 14 of the code of federal regulations, part 137, operator, had a tire blow out on take-off roll. The take-off was…Accident 20070716012619ABell UH1H · Benchmark, MT(-23) Pilot was attempting to sling load fire fighting equipment out of a remote heli-site in a burned area. The heli-site had been unapproachable for several days due to smoke. During takeoff, smoke quickly entered area and pilot lost visual references.…Accident 20070716012489ACessna 172M · Throckmorton, TX(-23) Pilot departed private strip southbound and turned to the west. Pilot stated that he had initially gained approximately 300' altitude and then descended. At approximately 2 miles from private strip at an altitude of approximately 18' the aircraft…Incident 20070715825949IPiper PA31T · Cleveland, OH(-23) On July 15, 2007, the pilot [privacy data omitted], an FAA certificated commercial pilot (PIC), reported sustained smoke/fumes in the cockpit of N650RS, a Piper model PA-31T during climb after departing cgf enroute to leb. This event occurred shortly…Incident 20070715023659IBeech 35B33 · Oklahoma City, OK(-23) A BE-33 N8833M piloted by the owner [privacy data omitted] on a part 91 flight landed at Page airport (F29) in yukon, Oklahoma. Upon landing the left main landing gear folded followed by the nose gear. The right main gear folded partially but did not…Incident 20070715021129ITmpson Navionb · Marathon, FL(-23) On July 15, 2007, the pilot [privacy data omitted] attempted to land his navion, registered as N5436K, using runway 07 at mth. The pilot, [privacy data omitted] the PIC, with one occupant. The right main landing gear did not extend/lower during the…Accident 20070715020019AAirtrc AT301 · Osceola, ID(-23) Pilot started his duty day at 0800 and had been flying all day spraying fields. At approximately 1530 he started flying a path going south into a corn field flying a very short area where he had to clear a tree line on both sides of the field. The…Accident 20070715019589AMooney M20J · Minneapolis, MN(-23) Pilot reported that the aircraft initiated an uncommanded yaw to the left after the take off and had reached an altitude of approximately 8 feet AGL. Pilot stated that full and opposite aileron and rudder inputs were initiated but had no effect on the…Incident 20070715019159IDhav DHC8102 · Lititz, PA(-23) Piedmont flight H318 in route from MDT to phi diverted to lns with smoke in cabin. Aircraft was evacuated on taxiway with no injuries. Aircraft ferried to MDT.Accident 20070715017169ACessna 182S · New River, AZ(-23) N2454M departed from ksdl at 3;13AM on July 15, 2007 enroute to its home base of kprc. Radar tracks show that the pilot followed a straight path toward kprc until its last radar return at 33 degrees 58'22"n and 112 degrees 1'21"w, at an altitude of…Accident 20070715016749AScwzer G164B · Sheldon, IL(-23) The pilot of an agricultural aircraft loaded for spraying, attempted to take off on a grass runway with a slight tail wind. In doing so, the aircraft lifted off but was not able to climb due to its weight and performance capabilities. The aircraft…Accident 20070715015579ABnorm BN2A20 · Stanley, ID(-23) After dropping off 8 passengers, the islander took off from Stanley airport, upon reaching 300 ft AGL, the port enigne lost power so pilot decided to return to airfield. During his return, he lost altitude and speed so he decided to land in a field…Accident 20070715015079ANamer F51D · Camarillo, CA(-23) On landing rollout, first solo flight in type, aircaft abruptly achieved lift and climbed off runway between 30 and 60 feet altitude. Pilot added power quickly resulting in torque roll to the left. Aircraft, without adequate altitude or airspeed,…Accident 20070715014739ACessna 182B · Leadore, ID(-23) On July 15, 2007, at approximately 1241, a Cessna 182, N2625G, was taking off with [privacy data omitted] as pilot and two passengers on board. When the aircraft was 15 to 20 feet in the air, the pilot said they were hit by wind shear and forced the…Accident 20070715014009ACessna 172S · Beverly, MA(-23) Pilot statement: normal cross wind landing on rwy 16 with information romeo, winds 240 @ 16 gusts to 22 after initial flare and landing gust lifted plane and dropped on nose wheel collapsing strut.Incident 20070715013989IAmtr Firefly · Midland, TX(-23) On July 15, 2007, at approximately 1230 CDT, the pilot of an experimental research and development aircraft, model proxy aviation systems Firefly, executed a landing on runway 10, at Midland International Airport. During rollout, shortly after…Accident 20070715013389APiper PA18150 · Ontario, OR(-23) The pilot stated that the wind was 5 kt off the noses so he and his passenger decided to land on runway 32. Upon landing the aircraft bounced, the pilot added power and landed. Upon roll out the aircraft turned hard left and the right landing gear…Incident 20070715013109IBoeing 737490 · Juneau, AK(-23) While enroute from jnu to sit the red unsafe nose gear light illuminated. Reviewed qrh and contacted maintenance control and dispatch. Dispatch recommended return to jnu. Quality control tracks items of this nature through reliability reporting system.Incident 20070715012859ICessna 172S · Grand Island, NE(-23) On landing at central Nebraska regional airport, CE-172, N6018Z landed with a flat tire; there was no damage to the aircraft or injuries.Incident 20070715012809IRyan Navion · Perryville, MO(-23) The pilot was practicing takeoff and landings at Perryville Municipal Airport, Perryville Missouri (K02). The pilot stated he just forgot to lower the landing gear and landed gear up. The aircraft came to rest right on the centerline of the runway. He…Incident 20070715012749ICirrus SR22 · Reno, NV(-23) N254SR, SR22, IFR enroute concord, CA, to alpine, WY, declared an emergency and diverted to Reno-tahoe int'l airport due to engine problems and smoke in the cockpit. Aircraft lost engine power on approach and landed on runway 16L. Post incident…