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 20070127003959ICessna 172E · Payson, AZ(-23) While taxiing on ramp and turning into parking spot after landing, aircraft right wing impacted sign post next to parking spot.Accident 20070127000849ACessna 172S · Osteen, FL(-23) At 1300FT MSL, N20956, a Cessna 172SP, struck a buzzard. Damage to the right wing, outboard of the strut. Full deflection of left aileron was required to maintain control. The aircraft departed controlled flight and entered a spin/steep spiral, to the…Incident 20070126006479ICndair CL6001A11 · Pontiac, MI(-23) A/c N333KK was cleared to land on runway 9R at ptk. Braking action was reported as fair. Pilot indicated that landing and rollout was uneventful until he applied the brakes. He stated that braking action was actually poor. He proceeded to deploy the…Accident 20070126001839AJihlav KP5 · Moorpark, CA(-23) On January 26, 2007, N215KP, a jihlavan/KP5, operating as a light sport aircraft, force landed in a field under unknown circumstances. After executing the forced landing, based upon the tracks left in the soil by the landing gear, the aircraft traveled…Incident 20070126001689ICessna 172RG · Pell City, AL(-23) Upon touchdown on runway 02 at Pell City, Alabama airport (plr) right brake locked and aircraft departed the runway to the right. The nose gear then collapsed causing minor damage to the aircraft. No injuries reported. [privacy data omitted]Accident 20070126001299AAirbau Classic · Sebring, FL(-23) N757LW made an emergency landing, due to the wake turbulence created from a landing hawkerjet, HS-125 (xa-ueh). Instructor of N757LW stated that he checked the pattern for traffic, made a radio call of his intentions, then positioned the aircraft on rwy…Accident 20070126000889AOnedes DR107 · Dallas, TX(-23) On Friday January 26, 2007 I responded to a call from the FAA regional coummunications center regarding an accident in rockwall county Texas at rockwall airpark east (1F7) at approximately 1745 hours. I contacted the rockwall county sheriff's department…Accident 20070126000869ACessna 172R · Olathe, KS(-23) The pilot [privacy data omitted] was attempting his first landing of the day in a gusty crosswind of about 12 knots crosswind component. He allowed the wind to drift him to the left edge of the paved runway where his left main landing gear tire caught a…Incident 20070126000779IBeech 95B55 · Dothan, AL(-23) The pilot stated he had just completed a normal landing on runway 32 at Dothan airport (dhn). Upon rollout he thought that he must have flipped the landing gear switch, thinking it was the flap lever. The aircraft landing gear collapsed traveling at…Incident 20070126000669ICessna 172RG · Coalinga, CA(-23) On 01/26/2007, at approximately 1050 hours PST, the pilot [privacy data omitted], pilot-in-command of Cessna aircraft, N5552R, landed at the Harris Ranch Airport (3O8), Coalinga, CA, with the landing retracted. N5552R was operating under 14CFR91 in VFR…Incident 20070125832279ICndair CL6002B19Flight crew did not divert to nearest airport. Eir may be done. AD compliance may not have been accomplished or been ineffective. Eir may be done.Incident 20070125006379IBeech B200 · Dayton, OH(-23) Enroute from luk to day, crew reported an unsafe gear indication. The aircraft landed at day without incident. Aircraft was released to maintenance.Incident 20070125003229IDoug DC983 · Reno, NV(-23) Aircraft was parked at the gate. Approximately ten minutes prior to departure the fuel truck drove up to the aircraft from the right rear of the aircraft. In the turn around the wing tip, the tank portion of the truck passed underneath the right wing…Incident 20070125001819IDoug MD88 · Ft Lauderdale, FL(-23) During aircraft pushback, tow bar connection failed. Towbar damaged right hand nose landing gear door. Aircraft APU was inoperative and air start cart was used prior to pushing back aircraft. Delta reenacted incident and concluded that towbar did not…Incident 20070125001359IBoeing 737824 · Mexico City, Mexico(-23) This incident occurred while the aircraft was taxiing for departure in Mexico City. The Continental aircraft taxied behind a copa aircraft and the left winglet contacted the copa aircraft. The Continental aircraft will be ferried to the houston, Texas…Incident 20070125000689IPiper PA23250 · Omaha, NE(-23) On approach to millard airport, Omaha, NE, the pilot reported that he had an unsafe gear indication. The pilot diverted to Eppley Airfield, Omaha, NE. Upon touchdown the landing gear green light came on. Maintenance found the left main landing gear…Incident 20070125000609IVeloci Sefg · Albuquerque, NM(-23) On January 25, 2007 at 1320 MST a velocity se-fg, N246RR, registered to rocket racing, inc., landed short of runway 8 at Albuquerque international sunport (abq) while on a local personal flight. Visual meteorological conditions prevailed at the time and…Incident 20070124016899IPiper PA24180 · Reedley, CA(-23) Inspection was completed of this aircraft following a gear-up landing at Reedley muni, Reedley CA. The aircraft received minor damage to the landing gear and the belly of the aircraft. A prop strike occurred with damage to the prop and will be removed…Incident 20070124010009IConaer LA4200 · West Palm Beac, FL(-23) The pilot [privacy data omitted] (the pilot and sole occupant of this amphibious aircraft) departed gilbert airport (kgif) in winter haven, FL on a return trip to Palm Beach county park (klna) in lantana, FL. When the aircraft was approximately 12.5…Accident 20070124008259ARyan Navion · Marco Island, FL(-23) On January 24, 2007, the pilot [privacy data omitted] attempted to take off in his Navion, registered as N4456K, using runway 17 at mky. The pilot [privacy data omitted], the PIC and only occupant indicated the engine started to run rough during the…Accident 20070124002369ACessna 402B · Milwaukee, WI(-23) N7886Q, a freight runners express Cessna 402 aircraft, while taxiing to the cargo ramp, collided in the taxiway intersection at a and A2, with another freight runners express Beech 99, N699CZ. A fire broke out upon impact. Egress from the emergency exit…Accident 20070124002349ABeech 99A · Milwaukee, WI(-23) N699CZ, a freight runners express Beech 99 aircraft, while taxiing to the cargo ramp, collided in the taxiway intersection at a and A2 with another freight runners express Cessna 402, N7886Q. A fire broke out upon impact. Egress from the emergency exit…Incident 20070124001169IPiper PA24250 · Lodi, CA(-23) Pilot was on a planned VFR flight from sts to sck and was proceeding as normal when, at approx. 1135 hours, he attempted to contact sck tower, was unable to transmit but could hear. After trying another mic with no success he departed the pattern and…Incident 20070124001119IYaklev YAK52 · Santa Rosa, CA(-23) On January 24, 2007 at 1400 hrs, shortly after landing on runway 14 at Sonoma County Airport during landing roll-out the left hand main gear collapsed. This caused minor damage to the left wing tip and aileron, tail skid and rudder.Accident 20070124001059ACessna 152 · Mcalester, OK(-23) On January 24 at 1605Z, N49053 a CE-152 was involved in a landing accident at the Mcalester municipal airport (kmlc). The student pilot was on her first solo cross country flight which was to be a round robin from richard lloyd jones (rvs) in tulsa…Accident 20070124000519ACessna 550 · Butler, PA(-23) Crew attempted landing with aircraft above vref and point of touch down with approximately 2,200 feet of runway remaining on runway surface described as braking action "fair".Incident 20070124000489ICessna 182P · Dermott, AR(-23) On 01/24/2006, 1100 CDT, a Cessna 182, registered to wesco contracting company piloted by [privacy data omitted], struck a power line while attempting to land highway 165 near jerome, AR, visual meteorological conditions prevailed. Subsequently the…Accident 20070124000419AAmtr Pittsspecial · Stockton, CA(-23) In an interview with the pilot he stated on take off the engine could only develop 1800 rmp. The pilot decided to abort take off. With the tail wheel off the ground the pilot case the throttle off to decrease rmp. With only rudder control the aircraft…Accident 20070123001259ACessna 172D · Beaver Marsh, OR(-23) Lost power for unknown reason. Notified zse of problem while under flight following. Attempted carb-heat application, changed throttle setting and mixture setting. Checked fuel selector. Engine eventually quit running. Attempted to reach Beaver Marsh…Accident 20070123001069AGreenh LANCAIR32036 · Guntersville, AL(-23) After flying for thirty minutes, the pilot detected the smell of fiberglass. The pilot made a landing on runway 03 Guntersville, AL (8A1). After clearing the runway the pilot detected the smell of smoke. The pilot shut the engine down after clearing the…Accident 20070123000839ACessna 140 · Murrieta/Temecu, CA(-23) After exiting the runway onto the taxiway, aircraft nosed over, stopping inverted.Incident 20070123000789IPiper PA28161 · Westerly, RI(-23) Student pilot on first solo cross country flight went off r/w 07 at (wst) Westerly RI at 1110EST. Left cross wind from 340/12 KTS. R/w wet with patchy snow on surface. Damage to a/c consisted of minor dents on lower wing surface and both flaps. IA…Incident 20070123000629IYoung PITTSS1SE · Fallbrook, CA(-23) On January 23, 2007, about 1000 hours PST, pitts N431ED, landed short and struck the sloped embankment prior to the runway L18 at the Fallbrook, CA airport. The sole occupant-pilot was not injured. Minor aircraft damage.Accident 20070122002789APiper J3C65 · White Lake, SD(-23) On January 22, 2007 at 1430 CST a Piper J3 operated by the pilot [privacy data omitted] was landing on a road near his family farm when he lost control in a crosswind and struck a road approach which flipped the aircraft over. The aircraft sustained…Incident 20070122002499IBeech E35 · El Cajon, CA(-23) Pilot stated that on approach to land, he had trouble hearing the radio and the lights in the cockpit did not seem to be working. He further stated that he could hear the landing gear motor when the gear was selected "down", but could not get a gear…Incident 20070122002459IBag B2062 · Conroe, TX(-23) Aircraft touched down on the runway and the nose gear collapsed causing a prop strike on both engines. Pilot stated the gear was indicating 3 green lights and the nose gear was observed through a mirror to be down prior to landing. The aircraft…Incident 20070122001729IPiper PA28161 · Melbourne, FL(-23) Both pilots stated that after completing 4 or 5 touch and goes, they noticed a vibration coming from the right main landing gear. They stated that it felt like they had a flat tire. They further stated that they then taxied to the ramp, stopped the…Incident 20070122000619IBoeing 737401 · Miami, FL(-23) On January 22, 2007 us airways flight #1898, while on pushback at Miami International Airport struck a catering truck. The aircraft was struck at approximately sta. 847 l/h side 112" forward and 12" below the L2 door. Line maintenance in Miami verified…Accident 20070121002239AGenbal AX6GENERAL · San Martin, CA(-23) The pilot failed to use the propane burner early enough to create sufficient hot air to arrest the landing descent. The effect of cold weather reducing the burner output (propane pressure) was a surprise to the pilot. During the landing attempt the…Incident 20070121001759ISocata TB20TRINIDAD · Torrance, CA(-23) On January 21, 2007 at 2100 PST, Socata TB20 a/c, N711RP, s/n: 1081 landed at toa rwy 29R with the landing gear up. This flight was from bermuda dunes, CA to toa via cno. The pilot stated he noted an intermittent alternator light prior to landing at cno…Incident 20070121001479ICndair CL6002B19 · Middletown, PA(-23) Flaps failed at zero degrees at 8,000 feet. Crew completed qrh and reported flap failure indication while inbound to kmdt. The aircraft landed and taxied to the ramp without incident.Accident 20070121001319ARobsin R22BETA · Salem, OR(-23) The pilot [privacy data omitted] is a student helicopter pilot; flight instructor at the time of accident was [privacy data omitted] . The two pilots took off from sle and flew together earlier in the morning beginning at 0955. At 1015 they landed at…Accident 20070121001279ASwrngn S2RG6 · Wauchula, FL(-23) On January 21, 2007 at 0910 EDT an ayers corporation model S2R-G6, N3209X, registered to ag flying service inc. had the right side fixed landing gear collapse after landing at Wauchula Municipal Airport in Wauchula, FL. Visual meteorological conditions…Accident 20070121001049ACessna 182E · Rchmond/Ashland, VA(-23) The pilot was accomplishing take offs and landings for night currency. On the third take off, after the aircraft was airborne, the pilot's seat unlatched and moved to its most aft position. The pilot elected to close the throttle and land on the runway.…Accident 20070121000469APiper PA60601P · Craig, CO(-23) The pilot made an approach into Craig-Moffat Airport after a snow berm moved through the area. The airport had not been plowed since the snow fall, the entire landscape was white with no contrast. Upon visual contact with the runway environment he…Incident 20070120007349IPiper PA34200T · Salem, OH(-23) Pilot stated that he was preoccupied with the cowl flaps because they were sticking and he forgot to put the landing gear handle down, which he landed gear up at 38D at approx. 1600 hrs. No injury. [privacy data omitted]Incident 20070120003009ICessna 207A · Kwigillingok, AK(-23) Immediately following touchdown on Kwigillingok rwy 15, the aircraft crossed a laterally oriented runway surface frost heave and became airborne. The pilot failed to maintain directional control, which resulted in the aircraft touching down with its…Accident 20070120002319AAmtr SONERAI2L · Alma, MI(-23) Engine failed to develop sufficient power to maintain flight, aircraft descended into wooded swamp area short of airfield/runway.Accident 20070120001519AAmtr CHALLENGER1 · Orland, CA(-23) On January 20, 2007, the glenn county sheriff's department reported to the FAA an ultralight vehicle crashed in an orchard near Orland, California. They reported that the accident happened at approximately 1600 PST. They reported substantial damage to…Incident 20070120000749ICessna 208 · Friday Harbor, WA(-23) Upon landing roll out at Friday Harbor, WA, kenmore flight #5405 collided with a large bird on the leading edge of the right wing near the wing root. The aircraft continued to parking with no problems. No injuries to the pilot or the five passengers on…