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 20071006825219ACubcft CC11100 · Laurel, MS(-23) Aircraft N954Z taxied behind a Learjet N631SF during a maintenance run. N954Z was blown around bending right wing spar.Accident 20071006824649ACessna 172N · Oxford, MS(-23) After departing on runway 9 at University-Oxford Airport (uox) in Mississippi, the aircraft banked to the left and impacted the tree line that was north east of the runway approximately 200 yards away. The aircraft sustained substantial damage. When the…Incident 20071006824389IBell 206L1 · Galveston, TXOn October 6, 2007, at 0801 CST, a Bell BT-206-L1, N3899C, registered to air logistics LLC, lost power during take-off from an off-shore production platform in the gulf of Mexico southeast of Galveston, Texas during a part 135 air carrier flight. Visual…Accident 20071006823839ALet L13BLANIK · Hemet, CA(-23) N510CS, blanik L-13, piloted by [privacy data omitted], private pilot glider, struck airport boundary fence short of runway 22 while landing at Hemet, CA, airport at 1300 PDT. The aircraft was substantially damaged while the sole occupant was not…Accident 20071006023779AAmtr Madmaxiispec · Blacksburg, VA(-23) On October 6, 2007, a two place mad max ii experimental amateur-built gyrocopter made several flights from Virginia tech montgomery executive airport (bcb) in Blacksburg, VA. The pilot and a passenger were intending pleasure flights to and around the…Incident 20071006023259ICessna 210D · Wenatchee, WA(-23)After a flight of about one hour for instrument flight training, the nose gear failed to extend upon return to the airport. The pilot reported that the emergency hand pump handle felt "locked up" and was unable to operate it normally. The aircraft landed…Incident 20071006021469IPiper PA28181 · San Carlos, CA(-23) On October 06, 2007 at approximately 10:11 PDT, a Piper PA28-181 archer, ran off the right side of the runway 12 during landing at San Carlos Airport, San Carlos, CA (ksql) approximately 1170 feet from the end. Local weather at the time of the incident…Accident 20071005829789ACirrus SR22 · Hartford, CT(-23) On October 5, 2007 N5205X (Cirrus SR-22) was taxiing on bravo (b) at Brainard airport, Hartford, CT (hfd). As N5205X taxied in, the right seat occupant told the pilot [privacy data omitted] that he was too FAR to the right. The pilot [privacy data…Incident 20071005824909IPiper PA28181 · Muncie, IN(-23) On 10/05/2007 at approximately 15:25 EST a student pilot operating a PA-28, N988JF was returning to kmie from a solo cross country flight. The student did a go around on the first landing attempt. On the second attempt the aircraft touched down on the…Incident 20071005023609IBeech V35A · Denver, CO(-23) On October 5, 2007 at approximately 1600 MDT, N7819R, a Beech bonanza model BE-V35A, experienced a gear up landing at the Centennial Airport (apa) Denver, Colorado. The aircraft sustained minor damage. The private pilot and his passenger were not…Accident 20071005023079APiper PA28140 · Cajon Junction, CA(-23) Aircraft struck the ground at a substantial speed. The nose wheel and lower gear arm and the left hand wheel, gear and tire departed the aircraft on initial impact. On second impact the propeller, engine cowling and other aircraft pieces departed the…Accident 20071005022989ACessna 150H · Clarksville, AR(-23) On October 5, 2007, at 11:15 CDT, a CE-150H, N22899, collided with a power line while executing a takeoff from Clarksville Municipal Airport (H35), Clarksville, Arkansas. The commercial pilot/flight instructor and student pilot were not injured and the…Accident 20071005022529ABbavia 7GCBC · Hoggard Mill, GA(-23) On 10/05/2007 the airman briefed with his CFI for a local 1.0 hours VFR flight from kbge direct keuf direct kbge. A weather brief from flight service was obtained. The aircraft left kbge at 1630L. At approximately 1700L the CFI attempted to make radio…Accident 20071005021879AAmtr Wrightflyer · Wright Patters, OH(-23) The aircraft was launched from the rail. Winds calm, visibility unrestricted. The pilot made a slight left turn to fly around the "u" shaped course. The aircraft pitched up and down frequently as it flew. As the aircraft made a right hand turn, it…Accident 20071005021009AAmtr Lancairlegay · Redmond, OR(-23) 10/05/2007 - N115YP reported to rdm tower that aircraft nose gear indicated unsafe condition. Pilot performed tower fly-by and tower verified that nose gear was not extended. Pilot performed a straight-in approach to rdm runway 28. Aircraft slid…Accident 20071004832499ARaythe C90A · Pagosa Springs, COPlan to make a recommendation that all fixed wing EMS flight operate uner IFR flight plans before, during and after patient pickup.Accident 20071004829799ACessna 170A · Wadesboro, NC(-23) Aircraft bounced after touching down. Aircraft veered left, the pilot applied power to correct. Aircraft continued left, departed runway and entered tall weeds. The pilot attempted to fly until right wing made contact with weeds, turning aircraft ninety…Incident 20071004826939IPiper PA24 · Cameron Park, CA(-23) Aircraft had charging system malfunction enroute. Upon arrival at destination pilot used emergency gear down procedures. Due to low electric system voltage, no positive "gear down" indication was observed prior to landing. Gear collapsed on rollout. No…Incident 20071004825799IPassen MK1 · Northport, MI(-23) Experimental amateur built aircraft operating as a light sport aircraft. Pilot stated that water was rough and upon beginning taking off, right pontoon stay wires snapped. He aborted takeoff and while taxiing the airplane tipped to right side and began…Accident 20071004825159AAviat A1B · Palmer, AK(-23) According to the pilot, he was attempting to land when aircraft left wing contacted brush. (-23 amendment) according to interviews with the air safety investigators for the operator, and the operator's written statement, the purpose of the flight was to…Incident 20071004824769IRyan Navion · Mesa, AZ(-23) Nose wheel collapsed on landing, for unknown reasons, damaging propeller and engine cowling.Accident 20071004824619AAmtr Searey · Cokato, MN(-23) Airman was on its 2nd flight of the demonstration phase of an amateur homebuilt-progressive aerodyne 'Searey' aircraft. While performing a water landing the aircraft flipped upside down, causing substantial damage. Weather was not a factor, the lake…Accident 20071004023769ACessna 172N · Calhan, CO(-23) PIC stated he was practicing soft field takeoffs and landings. On takeoff the airplane veered left into tall grass adjacent to the runway. Despite correcting for the left turning tendency the airplane continued off the runway and flipped onto its back…Incident 20071004022959IMooney M20J · St Petersburg-, FL(-23) On October 4, 2007 at 1210 EDT, a Mooney M20J, N3703H, operated by the pilot [privacy data omitted] sustained a gear up landing at saint Petersburg international airport (pie) st. Petersburg, Florida while on a personal part 91 flight. Visual…Incident 20071004022859IBeech 1900D · Kansas City, MO(-23) After take off from mci, the crew noted the captain's eadi had failed and smelled of electrical. Returned to field and told tower what was wrong. Ground control called out equipment. Aircraft landed safely.Accident 20071004022289APiper PA18150 · Lake Ouachita, AR(-23) 10/04/2007 N4157R a Piper PA-18 s/n 1809076 crashed into Lake Ouachita near the brady mountain campgrounds west of hot springs, Arkansas. Aircraft had departed north little rock (ork) enroute to hot springs (hot) and departed hot at approx. 15:50 cdl…Accident 20071004022259AIndusa T211THORPEDO · Denton, TX(-23) On 10/04/2007, at 1952CDT, a indus industries T211 thorpedo, N211LS, owned by hood aircraft corp., [privacy data omitted], houston Texas 770241132, during approach to landing for runway 17 at Denton muni (dto) experienced controlled flight into terrain…Accident 20071003828119APiper PA28180 · Fairview, TN(-23) The aircraft was enroute from shreveport, la (shv), to gallatin, TN (M33). Aircraft's engine experienced surging several times due to fuel exhausting. Attempts to restart the engine were unsuccessful. The aircraft crashed into a wooded area adjacent to…Accident 20071003825239APiper PA28181 · Walthourville, GA(-23) On 10/03/2007 at between 1800 and 1830L aircraft departed kand for a part 91 VFR personal flight direct to K2J2. No flight plan was filed. Pilot contacted savanna ATCT and requested flight following to K2J2. At 1953L savanna ATCT advised pilot, K2J2 was…Accident 20071003823899APiper PA18150 · Crowley Ranch, OR(-23) Very experienced retired airline pilot received fatal injuries when he had an in-flight collision with power lines and terrain near his airstrip located on his ranch. Witnesses to the crash stated that they observed the aircraft making numerous dives…Incident 20071003023229ILibrty LIBERTYXL2 · Viera, FL(-23) On October 3, 2007 at approximately 10:15 am, a liberty XL-2 (N513XL), on climb out from mlb, pilot door departed aircraft. Pilot declared an emergency and landed at mlb without incident. Pilot has a private pilot certificate. No injuries sustained.…Accident 20071003023169AAmtr Varieze · Norfolk, VA(-23) Preliminary information: on October 3, 2007, at about 1735, after takeoff from rwy 5 at cpk, in VMC, an airborne witness observed the aircraft takeoff and soon thereafter heard the pilot of N8VE report downwind, then base, and then a few seconds later…Accident 20071003020519APiper PA28151 · Salt Lake City, UT(-23) With intention to fly, taxied to runup area. Shut down engine and exited aircraft to retrieve headsets from cargo area. Returned to aircraft and from right seat started aircraft (no backfire or any other abnormality was observed during the start). While…Accident 20071002830529ADegeli 1 · Ashland, KY(-23) The pilot operated his single-place, amateur built, experimental category gyroplane on a FAR part 91 flight. The local flight was conducted out of kdwu at approx. 1815 local time. The pilot remained in the traffic pattern performing touch and gos. A…Incident 20071002830489ICessna T207A · Rock Springs, WY(-23) During landing pilot lost control of aircraft just before touch down and landed hard.Incident 20071002827369IPiper PA18 · Ivanof Bay, AK(-23) Pilot stated that he performed an off airport landing along a beach while out hunting in western Alaska near Ivanof Bay. Upon landing, the upper r/h main landing gear cabine fitting broke causing momentary loss of control with the l/h wing tip making…Accident 20071002825149ARobsin R44RAVENII · Lake Powell, UT(-23) The pilot/owner with his wife on-board intended to make a flight for pleasure from the boat to page, AZ. During lift-off the helicopter rolled over on the roof. The helicopter was secured to the roof-top helipad by a tie-down strap attached to each…Incident 20071002824039IBeech M35 · Atlanta, GA(-23) It appears that alternator belt failed at 7.5 NM west of kryy (mccollum) (found broken belt in engine compartment). Experienced electrical failure of receiving radio, used handheld to contact tower. Gear appeared to be down and locked according to green…Accident 20071002023059ACessna 172N · Espanola, NM(-23) The aircraft is owned and operated by tucson aeroservice center inc. and maintained by tucson aeroservice center inc. FAA certificated repair station YXUR055J (yxur) located in marana AZ. Investigation revealed the #3 cylinder exhaust rocker arm had…Accident 20071002022209ACambal Z105 · Rio Rancho, NM(-23) On October 9, 2007 at approximately 0830 local time, N1024B, a cameron model Z-105 balloon, serial number 6371, made a hard landing in Rio Rancho, new Mexico. The balloon had a pilot and 4 passengers on board. While attempting to land, the basket struck…Incident 20071002021499ICessna TR182 · Salinas, CA(-23) Pilot stated during preparation to land, the LH main landing gear would not extend. Pilot stated several attempts were made to lower the gear but all failed. Pilot stated, due to failed attempts to get the gear down, he opted to make an emergency…Accident 20071001021759AAmtr VANSRV6 · Halifax, VA(-23) During approach to land the pilot failed to secure the propeller in the manual mode. The pilot powered up to abort the landing and upon climb out, the increased engine RPM led the propeller to change to a low pitch to prevent overspeed situation. This…Incident 20071001021429ICessna T182T · Osage Beach, MO(-23) The pilot said he pushed the yoke forward after landing and got the airplane up onto two wheels. It turned right into the grass and ran through a shallow ditch. One propeller blade got bent on the ground contact and the nosegear forks were bent.…Incident 20070930830189IBeech 58 · Lancaster, PA(-23) During cruise flight, the pilot of N3159K noticed left engine oil pressure fluctuation and observed an excessive leak and a misting smoke trail. Pilot performed emergency shut-down, declared an emergency with harrisburg approach control. ATC provided…Accident 20070930826409APiper PA28R201T · Taos, NM(-23) On September 30, 2007 at approximately 0920 local time, the pilot of N38765, a Piper model PA28R-201T single engine turbo-charged airplane made an emergency landing due to experiencing a fire on board the aircraft. The personal flight originated from…Accident 20070930824729ARobsin R44 · Jackson Center, OH(-23) The pilot stated the following occurred during the landing phase of the flight: "I departed in a Robinson R44, N8353K from my residence at [privacy data omitted], enroute to hangar 1/2 mile west on same farm. The wind was out of the south. I felt a…Accident 20070930824709AAmtr Sportstar · Maple Lake, MN(-23) On 09/30/2007, at 1430 cdst, an evektor Sportstar, owned by m & s aircraft corp., and operated by the pilot [privacy data omitted] on a 14 CFR part 61 instructional flight, crashed on the south side of runway 10 at Maple Lake, MN (mgg) shortly after…Accident 20070930023739APiper PA28140 · Indiana, PA(-23) Student pilot making touch and go landing on runway 28 at Indiana county airport (idi) veered left of centerline, ran off the runway and over an embankment into a small ravine.Incident 20070930023209IDoug DC982 · Wichita, KS(-23) On September 30, 2007, at 1539 local time, the flight crew for American airlines, operating as flight AAL1548 departing albuquerque, new Mexico, (abq) for chicago Illinois (ord) diverted to Wichita, KS, (ict) due to pressurization problems. Upon landing…Accident 20070930023039ABeech F33A · Franklin, VA(-23) On or about 15:10, September 30, 2007 the commercial rated pilot and a safety pilot, who holds an ATP rating, departed (pvg) portsmouth, Virginia in route to fkn Virginia under VFR. According to the pilot, all operations were normal until the aircraft…